Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RMotta2408
Creator II
Creator II

Separating string content in a single column into multiple columns, dynamically

Hello everyone.

How do I extract a string content from a column into multiple columns?

I have this:

RMotta2408_0-1717768397438.png

 

And I want to turn it into this:

RMotta2408_1-1717768477428.png


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

 

Labels (2)
10 Replies
Shicong_Hong
Support
Support

see the below image, this expression create the columns based on the number of values in "Teams".

"team"+Numeric.sequence(row3.id,1,1)

Shicong_Hong_2-1718157598808.png