Hi Team,
I have 1 column name as "Product". I would like to split product column into 2 save in different SQL columns.
Input:
Product
Item1; Item2;Item3;Item4
I need output like
----------------------------
Product1 |
Product2
Item1 | Item2
----------------------
As i am new to talend studio i could not able to figure it which component is suitable in Talend.
Can any one suggest me.