Forum Discussion
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
Each table can contain 0-4 rows, 1 row = 1 language
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...
Hi Arthurle2000
It's possible. First add a custom column with Table.Column([Languages],"lookupValue")
Then expand above custom column and select "Extract Values...". Select a delimiter per your need.
Finally split above column with the delimiter you selected.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
5 Replies
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?
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:
For example the ID 201 that have more than one user it creates more than one line for the same ID
I need that in this cases the 2 mails keept in one line separed by a comma
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")
Then expand above custom column and select "Extract Values...". Select a delimiter per your need.
Finally split above column with the delimiter you selected.
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
