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

Anonymous — Sat, 16 Nov 2024 02:40:31 GMT

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!

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