Forum Discussion

rshh's avatar
rshh
New Member
2 years ago
Solved

Combining header names and values for all rows into new column

Hi folks,   I am new in this community and I hope someone can help me with this slightly unusual problem. I did a lot of web research without success, but maybe I did not ask the right questions. ...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    hello, rshh 

     

    let
    Source = your_table,
    cols = List.Buffer(Table.ColumnNames(Source)),
    p_info = Table.AddColumn(
        Source, "ProductInformation",
        (x) => 
            [a = List.Zip({cols, Record.FieldValues(x)}),
            b = List.Select(a, (w) => w{1} <> null),
            c = List.Transform(b, (w) => w{0} & ": " & Text.From(w{1})),
            d = Text.Combine(c, ", ")][d]
    )
in
    p_info

     

AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
2 years ago
Write column names and values into a single field using ': ' as separator

rshh we still have a list at this point. This line transforms this list from list of pairs to the list of single (text) values. Next step combines these values into a text string. Other than this you are right.

I modified my original code a little bit. Now I simply add new column with the same set of transformations (was Table.ToList >> transformations >> Table.FromList). 

rshh's avatar
rshh
New Member
2 years ago

Thanks for the clarification and the code update!