Forum Discussion

cheezy's avatar
cheezy
Icon for Helper I rankHelper I
4 years ago
Solved

Multivalue column split into table?

i have a datasource that is converted  into a table. There are columns within the table that contain multivalues separated by a semi colon, So for example like this: ID Department Years Colour...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi cheezy ,

     

    If I took your question correctly then you could follow below steps:-

    1. Select Department column then use split column by delimiter

    2. Now select the options as below:-

    3. Follow the same for colour column.

    4. Final output:-

     

    Refer the file below.

     

    Thanks,

    Samarth

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi cheezy ,

 

If I took your question correctly then you could follow below steps:-

1. Select Department column then use split column by delimiter

2. Now select the options as below:-

3. Follow the same for colour column.

4. Final output:-

 

Refer the file below.

 

Thanks,

Samarth

 

  • cheezy's avatar
    cheezy
    Icon for Helper I rankHelper I
    4 years ago

    thanks  for your help - this works