Forum Discussion
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...
NewStep=Table.FromRecords(Table.Group(#"Filtered Rows1","PROPERTY",{"n",each Table.Sort(_,{{"IMPORTKEY", Order.Ascending}, {"SYSTEMDATE", Order.Descending}}){0})[n])
NewStep=Table.FromRecords(Table.Group(#"Filtered Rows1","PROPERTY",{"n",each Table.Sort(_,{{"IMPORTKEY", Order.Ascending}, {"SYSTEMDATE", Order.Descending}}){0})[n])
THANK YOU!
This works perfectly and as I suspected, relatively simple.