group_keep_all_columns
Group data by keys while preserving all columns, preventing the loss of non-aggregated columns. Appends M query steps to expand the grouped table dynamically.
Instructions
Group By keeping ALL columns: Table.Group with {each _} then expand the grouped table over its non-key columns - the workaround for the editor's Group By dropping non-aggregated columns. The expanded set is derived at evaluation time so it survives schema drift. keys is comma-separated. Appends two steps to the table's M query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| keys | Yes | the grouping key columns, comma-separated | |
| table | Yes | ||
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |