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
Icon for Community Support rankCommunity Support
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.

Arthurle2000's avatar
Arthurle2000
Frequent Visitor
3 years ago

Thank you very much, it works perfectly