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...
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})
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})