Forum Discussion

efforting's avatar
efforting
New Member
3 years ago
Solved

Sort each column individually (over 100 columns)

Hello,    In power query, Is it possible with over 100 rows to sort each column so that all columns are in ascending order?    For example, once I load my data it looks like this:    Column ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hello, it worked for me, don´t know about how good or bad the performance might be, hope it helps.

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTICYmMgNgFiU6VYnWiwiCEKBokaQ9Uh1INETaA6IbpBsiBRUyjPFK4+NhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Column 1" = _t, #"Column 2" = _t, #"Column 3" = _t, #"Column 4" = _t, #"Column 5" = _t]),
    Custom1 = Table.ToColumns (Source),
    Custom2 = List.Transform(Custom1, List.Sort),
    Custom3 = Table.FromColumns(Custom2)
    in
    Custom3

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello, it worked for me, don´t know about how good or bad the performance might be, hope it helps.

 

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTICYmMgNgFiU6VYnWiwiCEKBokaQ9Uh1INETaA6IbpBsiBRUyjPFK4+NhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Column 1" = _t, #"Column 2" = _t, #"Column 3" = _t, #"Column 4" = _t, #"Column 5" = _t]),
Custom1 = Table.ToColumns (Source),
Custom2 = List.Transform(Custom1, List.Sort),
Custom3 = Table.FromColumns(Custom2)
in
Custom3