Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone.
How do I extract a string content from a column into multiple columns?
I have this:
And I want to turn it into this:
Mind you, the original column "TEAMS" may have a different number of values. So the Job has to be dynamic to create as many columns as the values in the original "TEAMS" column.
The "-" character is the values separator.
I just can't seem to get over this hurdle.
Can anyone please help me?
Thank you so much,
Rui
see the below image, this expression create the columns based on the number of values in "Teams".
"team"+Numeric.sequence(row3.id,1,1)