Forum Discussion

Caber's avatar
Caber
New Member
3 years ago
Solved

Creating new column by index

Hello everyone, I need help with manipulation in table. I have a table: Product Cat Index A AA 1 A AB 2 B AA 1 C AA 1 C AB 2 C AC 3 And i have to man...
Need Help
  • JW_van_Holst's avatar
    JW_van_Holst
    3 years ago
    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUXIEEYZKsTpQrhOQMAJznVBlnbFwEYrBXBBhrBQbCwA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Product = _t, Cat = _t, Index = _t]),
    #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[Index]), "Index", "Cat"),
    #"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,"",Replacer.ReplaceValue,{"1", "2", "3"})
in
    #"Replaced Value"

     

     

JW_van_Holst's avatar
JW_van_Holst
Resolver IV
3 years ago
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUXIEEYZKsTpQrhOQMAJznVBlnbFwEYrBXBBhrBQbCwA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Product = _t, Cat = _t, Index = _t]),
    #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[Index]), "Index", "Cat"),
    #"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,"",Replacer.ReplaceValue,{"1", "2", "3"})
in
    #"Replaced Value"