Forum Discussion

tall27's avatar
tall27
New Member
3 years ago
Solved

Transform list into comma-separated text.

Hi,

My json file allows multivalue in the field, that result in different results in the table. 

after the import, I can see 'lists' and  the values (for a single value).

 

I struggle to expand all lists, and show all channels in the same cell

is it possible to achieve ?

Thank you ahead!

Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hi, tall27 

    Table.TransformColumns(source_table, {"column_name", (x) => if Value.Type(x) = type list then Text.Combine(List.Transform(x, Text.From), ", ") else x})

1 Reply

  • AlienSx's avatar
    AlienSx
    Super User
    3 years ago

    Hi, tall27 

    Table.TransformColumns(source_table, {"column_name", (x) => if Value.Type(x) = type list then Text.Combine(List.Transform(x, Text.From), ", ") else x})