Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tall27
New Member

Transform list into comma-separated text.

Hi,

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

tall27_0-1679673811640.png

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

tall27_1-1679673856320.png

 

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

tall27_3-1679674301092.png

is it possible to achieve ?

Thank you ahead!

1 ACCEPTED SOLUTION
AlienSx
Super User
Super User

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

View solution in original post

1 REPLY 1
AlienSx
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors