Forum Discussion

CRDover's avatar
CRDover
Frequent Visitor
4 years ago
Solved

Table.Sort nested Tables

I am looking to sort in Power Query a all nested tables in a column like in the sample. I am not sure how to even begin to do that.

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Table.AddColumn(TableOrPriorStepName, "NewSortedTables", each Table.Sort(_[Nested Table Column], {{"Nested Header", Order.Ascending},  {"Nested Value, Order.Ascending}}))

     

    --Nate

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Table.AddColumn(TableOrPriorStepName, "NewSortedTables", each Table.Sort(_[Nested Table Column], {{"Nested Header", Order.Ascending},  {"Nested Value, Order.Ascending}}))

     

    --Nate