topic Split input to multiple row in Talend Studio https://community.qlik.com/t5/Talend-Studio/Split-input-to-multiple-row/m-p/2369485#M132626 <P>Hi,</P><P>&nbsp;</P><P>Please could you help me split string into multiple row with space.</P><P>&nbsp;</P><P>example below.</P><P>&nbsp;</P><P><U>input</U></P><P>&nbsp;</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; description</P><P>a123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;abc def&nbsp; ghi</P><P>b123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;abc def ghi jkl</P><P>&nbsp;</P><P>output</P><P>&nbsp;</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Description</P><P>a123&nbsp; &nbsp; &nbsp; &nbsp; abc</P><P><SPAN>a123&nbsp; &nbsp; &nbsp; &nbsp; def</SPAN></P><P><SPAN>a123&nbsp; &nbsp; &nbsp; &nbsp; ghi</SPAN></P><P>b123&nbsp; &nbsp; &nbsp; &nbsp; abc</P><P><SPAN>b123&nbsp; &nbsp; &nbsp; &nbsp; def</SPAN></P><P><SPAN>b123&nbsp; &nbsp; &nbsp; &nbsp; gfh</SPAN></P><P><SPAN>b123&nbsp; &nbsp; &nbsp; &nbsp; ijk</SPAN></P><P>&nbsp;</P><P><SPAN>Regards</SPAN></P> Wed, 04 Oct 2017 22:34:29 GMT Anonymous 2017-10-04T22:34:29Z Split input to multiple row https://community.qlik.com/t5/Talend-Studio/Split-input-to-multiple-row/m-p/2369485#M132626 <P>Hi,</P><P>&nbsp;</P><P>Please could you help me split string into multiple row with space.</P><P>&nbsp;</P><P>example below.</P><P>&nbsp;</P><P><U>input</U></P><P>&nbsp;</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; description</P><P>a123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;abc def&nbsp; ghi</P><P>b123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;abc def ghi jkl</P><P>&nbsp;</P><P>output</P><P>&nbsp;</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Description</P><P>a123&nbsp; &nbsp; &nbsp; &nbsp; abc</P><P><SPAN>a123&nbsp; &nbsp; &nbsp; &nbsp; def</SPAN></P><P><SPAN>a123&nbsp; &nbsp; &nbsp; &nbsp; ghi</SPAN></P><P>b123&nbsp; &nbsp; &nbsp; &nbsp; abc</P><P><SPAN>b123&nbsp; &nbsp; &nbsp; &nbsp; def</SPAN></P><P><SPAN>b123&nbsp; &nbsp; &nbsp; &nbsp; gfh</SPAN></P><P><SPAN>b123&nbsp; &nbsp; &nbsp; &nbsp; ijk</SPAN></P><P>&nbsp;</P><P><SPAN>Regards</SPAN></P> Wed, 04 Oct 2017 22:34:29 GMT https://community.qlik.com/t5/Talend-Studio/Split-input-to-multiple-row/m-p/2369485#M132626 Anonymous 2017-10-04T22:34:29Z Re: Split input to multiple row https://community.qlik.com/t5/Talend-Studio/Split-input-to-multiple-row/m-p/2369486#M132627 <P>Take a look at the tNormalize component. That will solve this problem for you. Here are instructions:&nbsp;<A href="https://help.talend.com/reader/g8zdjVE7fWNUh3u4ztO6Dw/PCoAqHiZrLEYPgz5Byu7XQ" target="_blank" rel="nofollow noopener noreferrer">https://help.talend.com/reader/g8zdjVE7fWNUh3u4ztO6Dw/PCoAqHiZrLEYPgz5Byu7XQ</A></P> Wed, 04 Oct 2017 23:33:36 GMT https://community.qlik.com/t5/Talend-Studio/Split-input-to-multiple-row/m-p/2369486#M132627 Anonymous 2017-10-04T23:33:36Z