Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a line like this :
1,ted,ball,house~office~ship~school.
I want to split the above line into this:
1,ted,ball,house
1,ted,ball,office
1,ted,ball,ship
1,ted,ball,school
Can you help ?
Hello,
Please have a look at this component TalendHelpCenter: tExtractDelimitedFields which generates multiple columns from a delimited string column.
You can use it to split your line with "~" filed separator and join other columns via tMap component.
Best regards
Sabrina