Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Table.Group for AllRows without hardcoding the table columns

Hi All   I've been looking for a solution to not having to hardcode the table columns in the Table.Group statement of my query when doing a Group for All Rows. Scenario, every day a file will be e...
  • wdx223_Daniel's avatar
    4 years ago

    NewStep=Table.FromRecords(Table.Group(#"Filtered Rows1","PROPERTY",{"n",each Table.Sort(_,{{"IMPORTKEY", Order.Ascending}, {"SYSTEMDATE", Order.Descending}}){0})[n])