Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a source table in my db with data like:
columndata list abc Paul;Michael;Benjamin;Latif def High;Medium;Low;NULLghi 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!