Split array into rows

[mohsenask]

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 that record. IS there a transformation option for that. 

[Mikelytics · Accepted solution]

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.