Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Spliting rows with spicific columns

Hello Everyone and thank you in advance for your help, I'm struggling with this problem, here's an example:     I manage to split the rows using M but I can't find a way to make the split...
Need Help
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi Anonymous ,

    1. Check the column "Row" and unpivot other columns
    2. Check the resulting "Attribute"-column and extract the first 3 characters from it
    3. Pivot that new column with "Values" in the values-section

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago
let
    Source = Table.FromRecords(Json.Document(Binary.Decompress(Binary.FromText("lZC9CsJAEAbf5atT3F9ArlNjTEyh0RxyiG8QtBIL8d3V4/aygoXXzS4sM+zpgf31DisLHDonYTFfLBEGBXu5jWNgzdgwLon7wb+PdQDFlpqxYRwPn0X0K+avkh9VHWP+DJAlFagsvU76/ria9IN3WXojSC+FyAowKcC7dgrYbdsUgE2zBhWga2r8/ICihFkqiGQ+WV/28ws=", BinaryEncoding.Base64),Compression.Deflate))),
    ttc=Table.ToColumns(Source),
    c1=List.Repeat(ttc{0},5),
    sku=List.Combine(List.Range(ttc,1,5)),
    qty=List.Combine(List.Range(ttc,6,5)),
    tfc=Table.FromColumns({c1,sku,qty},{"idx","sku","qty"}),
    #"Ordinate righe" = Table.Sort(tfc,{{"idx", Order.Ascending}}),
    #"Filtrate righe" = Table.SelectRows(#"Ordinate righe", each ([sku] <> null))
in
    #"Filtrate righe"