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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors