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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to extract delimited data in a single row to multiple columns in Talend

I have a source table in my db with data like:

columndata list
abc        Paul;Michael;Benjamin;Latif
def        High;Medium;Low;NULL
ghi Yes;No;Yes;No

I would like to get the output in the target table (columns are already defined) like below:

abc      def    ghi  (column names)
Paul High Yes Michael Medium No Benjamin Low Yes Latif NULL No

Is there any simple way to extract the delimited data and load into repective columns in the target table in talendThanks!

Labels (4)
0 Replies