Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
DrGenious
Creator
Creator

Spli a line into multiple rows accoring the special character

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 ?

1 Reply
Anonymous
Not applicable

 

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.0693p00000AGXlxAAH.png0693p00000AGXlsAAH.png0693p00000AGXlnAAH.png0693p00000AGXliAAH.png0693p00000AGXldAAH.png 

 

Best regards

 

Sabrina