Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

Sorting all columns in one step

Dear all,

 

I have a table with many columns, and I need to sort them. Target is for me to speed up the grouping step, and I read some resoucres in the web that Grouping can be faster if the data are pre-sorted.

 

Coming back to the sorting, is there a way to make it in one step intead of making it for each column?

 

What I did on sample file is this one:

#"Sorted Rows" = Table.Sort(#"Removed Columns",{{"Region", Order.Ascending}, {"Port_Type_1_2", Order.Ascending}})

 

I was thinking of  using the following:

Headers = Table.ColumnNames(StuffingBoxChange2),
HeadersToRemove = List.Combine({{"Y3"},{"OEM_Y3_Volumes"},{"DISTRIBUTOR_Y3_Volumes"}}),
HeaderDifference = List.Difference(Headers,HeadersToRemove),

 

and at the end using HeaderDifference to select the column to sort.

 

Could you support?

 

Thanks.

  • Hi Mic1979 

     

    #"Sorted Rows" = Table.Sort(#"Removed Columns", List.Transform(HeaderDifference, each {_, Order.Ascending}))

     Stéphane

2 Replies

  • Hi Mic1979 

     

    #"Sorted Rows" = Table.Sort(#"Removed Columns", List.Transform(HeaderDifference, each {_, Order.Ascending}))

     Stéphane