apply_transform
Add a standard Power Query step to a query with predefined action and parameters, optionally after a named step.
Instructions
Add a standard Power Query step without hand-writing M. action and params come from list_transforms, e.g.
action='unpivot_other_columns', params={'keep_columns': ['Region']}; or action='group_by',
params={'group_columns': ['Region'], 'aggregations': [{'name': 'Total', 'operation': 'sum', 'column': 'Amount'}]}.
The step is appended to the end unless after_step names an earlier step (the next step is rewired, as the editor does).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| action | Yes | ||
| params | Yes | ||
| source | Yes | ||
| dry_run | No | ||
| step_name | No | ||
| after_step | No |