Forum Discussion
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 |
| 1 | Billing;Stores;Office | 3 | Red;Blue |
| 2 | Office;Billing | 7 | Green;Orange |
| 3 | Stores | 10 | pink |
So i am trying to extract the multivalue fields, perhaps put them into their own table? But i cannot see anyway of doing this after i have already converted the original datasource into a table. Any ideas?
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
2 Replies
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
thanks for your help - this works
