https://community.qlik.com/t5/Talend-Studio/transforming-a-String-that-has-multiple-rows-to-one-column/m-p/2269980#M48036 you have two tables which you want to join? If yes take trap and do the lookup on code agence. Fri, 27 Mar 2020 04:29:13 GMT manodwhb 2020-03-27T04:29:13Z https://community.qlik.com/t5/Talend-Studio/transforming-a-String-that-has-multiple-rows-to-one-column/m-p/2269979#M48035 <P>Hi,&nbsp;</P> <P>I am new in Talend , and i am dealing with trasforming a String value that has multiple rows to one column.</P> <P>I made a try with tnormalize but it doesn't work.</P> <P>the scenario is :</P> <P>i have a mail that contains 2 different tables and when I imported it to Talend it becomes a set of rows.<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="from mail" style="width: 451px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9Z2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128498iE13E54EE5B4914C3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9Z2.png" alt="0683p000009M9Z2.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">from mail</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="after reading the body of the mail in Talend" style="width: 328px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9Z7.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144594iBF911519F3CE58F0/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9Z7.png" alt="0683p000009M9Z7.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">after reading the body of the mail in Talend</SPAN></SPAN></P> <P>&nbsp;what I would like is to transform the output that I got in Talend in order to be like&nbsp; the original tables but at this time it will be printed on excel file.</P> <P>Any suggestion please.</P> <P>Thanks in advance.</P> Sat, 16 Nov 2024 02:52:09 GMT https://community.qlik.com/t5/Talend-Studio/transforming-a-String-that-has-multiple-rows-to-one-column/m-p/2269979#M48035 Anonymous 2024-11-16T02:52:09Z https://community.qlik.com/t5/Talend-Studio/transforming-a-String-that-has-multiple-rows-to-one-column/m-p/2269980#M48036 you have two tables which you want to join? If yes take trap and do the lookup on code agence. Fri, 27 Mar 2020 04:29:13 GMT https://community.qlik.com/t5/Talend-Studio/transforming-a-String-that-has-multiple-rows-to-one-column/m-p/2269980#M48036 manodwhb 2020-03-27T04:29:13Z