locked
Grouping unknown column names RRS feed

  • Question

  • Hi, 

    I have a query that I would like to use for a large number of data tables, however the query contains a Table.Group function and I would like to know how to define the individual column grouping/aggregation functions dynamically.

    Thanks,

    Joe

    Sunday, August 26, 2018 2:47 PM

Answers

  • Table.ColumnNames can be used to get a List of your columns. You can combine it with List functions to setup whatever sort of aggregation you're trying to do (like using List.RemoveItems to exclude a value column from an aggregation list).

    Monday, August 27, 2018 3:56 PM