Forum Discussion
mohsenask
Helper II
3 years agoSplit array into rows
I have data as below. Where the column has an array with comma separated values, Id like to split them into separate rows. So eventually every row will have one value in the column 'entity_id' for th...
- 3 years ago
Hi mohsenask
Use the split by column feature with row option:
Result
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Mikelytics
Resident Rockstar
3 years agoHi mohsenask
Use the split by column feature with row option:
Result
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.