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
Arthurle2000
Frequent Visitor

Expand table fields value with multiple rows

Hello !

 

I have an issue on my table User with a colunm "Languages" which contain tables. Here 1 row = 1 user

 

Capture d'écran_20230127_155252.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Each table can contain 0-4 rows, 1 row = 1 language 

Arthurle2000_0-1674833305982.png

I only need the lookupValue column to get every language for each user but i don't know how to exploit it. If i expand the column i only have 1 column with the first row of each table...

1 ACCEPTED SOLUTION

Hi @Arthurle2000 

 

It's possible. First add a custom column with Table.Column([Languages],"lookupValue")

vjingzhang_0-1675070438753.png

 

Then expand above custom column and select "Extract Values...". Select a delimiter per your need. 

vjingzhang_1-1675070538904.png

 

Finally split above column with the delimiter you selected. 

vjingzhang_2-1675070682694.png

vjingzhang_3-1675070731641.png

 

 Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

5 REPLIES 5
Arthurle2000
Frequent Visitor

Hi !

 

Thank you for your reply, it works well but i would like to have 4 columns ( 1 for each language ) instead of having multiples rows for each user. Is that possible ?

Hi @Arthurle2000 

 

It's possible. First add a custom column with Table.Column([Languages],"lookupValue")

vjingzhang_0-1675070438753.png

 

Then expand above custom column and select "Extract Values...". Select a delimiter per your need. 

vjingzhang_1-1675070538904.png

 

Finally split above column with the delimiter you selected. 

vjingzhang_2-1675070682694.png

vjingzhang_3-1675070731641.png

 

 Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Thank you very much, it works perfectly

v-jingzhang
Community Support
Community Support

Hi @Arthurle2000 

 

How did you expand the table column? You may try the following operation to expand it. Is the final result what you want? 

vjingzhang_0-1675056660074.png

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Hello, if I want to spand a table and there are spaces that have more than 1 value, it duplicates the ID in order to spand it. I want that if have more than one it separetes with a coma.

 

For example: 

 

Powerbiasks_0-1687365295476.png

Powerbiasks_1-1687365384674.png

 

For example the ID 201 that have more than one user it creates more than one line for the same ID

 

Powerbiasks_2-1687365429247.png

 

I need that in this cases the 2 mails keept in one line separed by a comma

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