Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Generalizing a table with column reduction

Dear community,   actually i want to solve an easy task but i am struggling and hope that someone can help me.   I have the following table:   Alfred Alfred_1 Alfred_2 Bert Bert_1 Bert_...
Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi,

     

    let
    Source = Your_Source,
    Name = List.Alternate(Table.ColumnNames(Source),2,1,1),
    Data = List.Transform(List.Split(Table.ToColumns(Source),3), each Table.FromColumns(_, {"Start", "End", "Value"})),
    #"Data+Name" = Table.FromColumns({Data}&{Name}, {"Data", "Name"}),
    Expand = Table.ExpandTableColumn(#"Data+Name", "Data", {"Start", "End", "Value"}, {"Start", "End", "Value"}),
    NotNull = Table.SelectRows(Expand, each [Start] <> null)
    in
    NotNull

     Stéphane

slorin's avatar
slorin
Super User
2 years ago

Hi,

 

let
Source = Your_Source,
Name = List.Alternate(Table.ColumnNames(Source),2,1,1),
Data = List.Transform(List.Split(Table.ToColumns(Source),3), each Table.FromColumns(_, {"Start", "End", "Value"})),
#"Data+Name" = Table.FromColumns({Data}&{Name}, {"Data", "Name"}),
Expand = Table.ExpandTableColumn(#"Data+Name", "Data", {"Start", "End", "Value"}, {"Start", "End", "Value"}),
NotNull = Table.SelectRows(Expand, each [Start] <> null)
in
NotNull

 Stéphane

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Awesome, thank you very much!