Forum Discussion

Arthurle2000's avatar
Arthurle2000
Frequent Visitor
3 years ago
Solved

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...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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.

  • Powerbiasks's avatar
    Powerbiasks
    New Member
    3 years ago

    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