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.

Arthurle2000's avatar
Arthurle2000
Frequent Visitor
3 years ago

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 ?

  • 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