https://community.qlik.com/t5/Talend-Studio/Split-1-column-into-2-columns-and-store-into-SQL-DB/m-p/2318463#M88801 <P>Hi Team,</P><P></P><P></P><P>I have 1 column name as "Product". I would like to split product column into 2 save in different SQL columns.</P><P></P><P></P><P>Input:</P><P>Product</P><P>Item1; Item2;Item3;Item4</P><P></P><P></P><P>I need output like</P><P>----------------------------</P><P>Product1 | </P><P>Product2</P><P>Item1 | Item2</P><P> ----------------------</P><P></P><P></P><P>As i am new to talend studio i could not able to figure it which component is suitable in Talend. </P><P>Can any one suggest me.</P><P></P><P></P> Wed, 13 Jan 2021 17:38:30 GMT Psade1606751688 2021-01-13T17:38:30Z https://community.qlik.com/t5/Talend-Studio/Split-1-column-into-2-columns-and-store-into-SQL-DB/m-p/2318463#M88801 <P>Hi Team,</P><P></P><P></P><P>I have 1 column name as "Product". I would like to split product column into 2 save in different SQL columns.</P><P></P><P></P><P>Input:</P><P>Product</P><P>Item1; Item2;Item3;Item4</P><P></P><P></P><P>I need output like</P><P>----------------------------</P><P>Product1 | </P><P>Product2</P><P>Item1 | Item2</P><P> ----------------------</P><P></P><P></P><P>As i am new to talend studio i could not able to figure it which component is suitable in Talend. </P><P>Can any one suggest me.</P><P></P><P></P> Wed, 13 Jan 2021 17:38:30 GMT https://community.qlik.com/t5/Talend-Studio/Split-1-column-into-2-columns-and-store-into-SQL-DB/m-p/2318463#M88801 Psade1606751688 2021-01-13T17:38:30Z