topic How to shift a column header names into row values in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370274#M133335 Hi, <BR />I have a scenario to be processed as below: <BR />1. An Input "|"delimited file to be processed which is of the below mentioned schema (with sample data): <BR />CARDID|CARDNAME|SLOTNAME|SHELFNAME|NODENAME|LOCATIONNAME|NODETYPE <BR />661813|DD|Slot 4|Shelf 1|T-T080176 _C01_R01|T-T080176|SDH <BR />661821|DD|Slot 4|Shelf 1|T-T080178_C01_R01|T-T080178|PDH <BR />661878|UU|Slot 1|Shelf 1|T-T090002_C01_R01|T-T090002|SDH <BR />661900|DU|Slot 3|Shelf 1|T-T050049_C01_R01|T-T050049|PDH <BR />661914|UU|Slot 1|Shelf 1|T-T050065_C01_R01|T-T050065|MSC <BR />3. The expected is to arrive at two output files where the first one is straight mapping as shown below(OUTPUT1): <BR />CARDID|CARDNAME|SLOTNAME|SHELFNAME|LOCATIONNAME <BR />661813|DD|Slot 4|Shelf 1|T-T080176 <BR />661821|DD|Slot 4|Shelf 1|T-T080178 <BR />661878|UU|Slot 1|Shelf 1|T-T090002 <BR />661900|DU|Slot 3|Shelf 1|T-T050049 <BR />661914|UU|Slot 1|Shelf 1|T-T050065 <BR /> <BR />The second file should be in the below mentioned format(OUTPUT2): <BR />CARDID|UDA_NAME|UDA_VALUE <BR />661813|NODENAME|T-T080176 _C01_R01 <BR />661821|NODENAME|T-T080178_C01_R01 <BR />661878|NODENAME|T-T090002_C01_R01 <BR />661900|NODENAME|T-T050049_C01_R01 <BR />661914|NODENAME|T-T050065_C01_R01 <BR />661813|NODETYPE|SDH <BR />661821|NODETYPE|PDH <BR />661878|NODETYPE|SDH <BR />661900|NODETYPE|PDH <BR />661914|NODETYPE|MSC <BR />In the above output you can see that the Input Header columns became the row values. I understand that this shall be achieved through using multiple tFileInputDelimited and tmap components for each of the column headers and atlast merging all the files to form a single output. <BR />The problem is there could be more number of columns which has to be processed in this fashion. So I am seeking help to achieve this in an easy manner. <BR />Regards, <BR />Karthik Tue, 20 Aug 2013 07:03:00 GMT Anonymous 2013-08-20T07:03:00Z How to shift a column header names into row values https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370274#M133335 Hi, <BR />I have a scenario to be processed as below: <BR />1. An Input "|"delimited file to be processed which is of the below mentioned schema (with sample data): <BR />CARDID|CARDNAME|SLOTNAME|SHELFNAME|NODENAME|LOCATIONNAME|NODETYPE <BR />661813|DD|Slot 4|Shelf 1|T-T080176 _C01_R01|T-T080176|SDH <BR />661821|DD|Slot 4|Shelf 1|T-T080178_C01_R01|T-T080178|PDH <BR />661878|UU|Slot 1|Shelf 1|T-T090002_C01_R01|T-T090002|SDH <BR />661900|DU|Slot 3|Shelf 1|T-T050049_C01_R01|T-T050049|PDH <BR />661914|UU|Slot 1|Shelf 1|T-T050065_C01_R01|T-T050065|MSC <BR />3. The expected is to arrive at two output files where the first one is straight mapping as shown below(OUTPUT1): <BR />CARDID|CARDNAME|SLOTNAME|SHELFNAME|LOCATIONNAME <BR />661813|DD|Slot 4|Shelf 1|T-T080176 <BR />661821|DD|Slot 4|Shelf 1|T-T080178 <BR />661878|UU|Slot 1|Shelf 1|T-T090002 <BR />661900|DU|Slot 3|Shelf 1|T-T050049 <BR />661914|UU|Slot 1|Shelf 1|T-T050065 <BR /> <BR />The second file should be in the below mentioned format(OUTPUT2): <BR />CARDID|UDA_NAME|UDA_VALUE <BR />661813|NODENAME|T-T080176 _C01_R01 <BR />661821|NODENAME|T-T080178_C01_R01 <BR />661878|NODENAME|T-T090002_C01_R01 <BR />661900|NODENAME|T-T050049_C01_R01 <BR />661914|NODENAME|T-T050065_C01_R01 <BR />661813|NODETYPE|SDH <BR />661821|NODETYPE|PDH <BR />661878|NODETYPE|SDH <BR />661900|NODETYPE|PDH <BR />661914|NODETYPE|MSC <BR />In the above output you can see that the Input Header columns became the row values. I understand that this shall be achieved through using multiple tFileInputDelimited and tmap components for each of the column headers and atlast merging all the files to form a single output. <BR />The problem is there could be more number of columns which has to be processed in this fashion. So I am seeking help to achieve this in an easy manner. <BR />Regards, <BR />Karthik Tue, 20 Aug 2013 07:03:00 GMT https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370274#M133335 Anonymous 2013-08-20T07:03:00Z Re: How to shift a column header names into row values https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370275#M133336 Hi, <BR />The component <A href="https://help.talend.com/search/all?query=tMap&amp;content-lang=en" target="_blank" rel="nofollow noopener noreferrer">tMap</A> can achieve your goal. <BR />The workflow should be: tfileinputdelimited--&gt;tMap--&gt;tfileoutputdelimited(output1) <BR /> --&gt;tfileoutoutdelimited2(output2) <BR /> --&gt;tfileoutoutdelimited3(output2) <BR />Please see my screenshots for detail. <BR />Best regards <BR />Sabrina <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAtx.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149522i1C940692123AD422/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAtx.png" alt="0683p000009MAtx.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAvn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/142952i500C07D92BAB5C9D/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAvn.png" alt="0683p000009MAvn.png" /></span> Tue, 20 Aug 2013 08:03:02 GMT https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370275#M133336 Anonymous 2013-08-20T08:03:02Z Re: How to shift a column header names into row values https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370276#M133337 Hi Sabrina,<BR />Thanks for providing the solution. I tried the same and got three output files in total, <BR />tfileoutputdelimited(output1)<BR />tfileoutoutdelimited2(output2)<BR />tfileoutoutdelimited3(output3)<BR />whereas I am expecting only two files <BR />Is there any simple way to merge both the Output 2 &amp; 3 files.<BR />Regards,<BR />Karthik Tue, 20 Aug 2013 10:58:12 GMT https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370276#M133337 Anonymous 2013-08-20T10:58:12Z Re: How to shift a column header names into row values https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370277#M133338 Hi Sabrina,<BR />I got the solution. I used tUnite to merge both the Output2 &amp;3 files to make it as a single file.<BR />Thanks for your support.<BR />Regards,<BR />Karthik Tue, 20 Aug 2013 11:11:34 GMT https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370277#M133338 Anonymous 2013-08-20T11:11:34Z Re: How to shift a column header names into row values https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370278#M133339 Hi, <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>tfileoutputdelimited(output1)<BR />tfileoutoutdelimited2(output2)<BR />tfileoutoutdelimited3(output3)<BR />whereas I am expecting only two files<BR />Is there any simple way to merge both the Output 2 &amp; 3 files.</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />Actually, you should use a same output file path when setting tfileoutoutdelimited2 and tfileoutoutdelimited3. <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>The workflow should be: tfileinputdelimited--&gt;tMap--&gt;tfileoutputdelimited(output1)<BR /> --&gt;tfileoutoutdelimited2(output2)<BR /> --&gt;tfileoutoutdelimited3(output2)</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />Please check out the option "Append" both in tFileoutputdelimited2 and tFileoutoutdelimited3 component. <BR />See my screenshots <BR />Best regards <BR />Sabrina <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAvs.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/155127i995C3626E0006EDA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAvs.png" alt="0683p000009MAvs.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAvx.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140597iA87F35AC83616AA3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAvx.png" alt="0683p000009MAvx.png" /></span> Tue, 20 Aug 2013 11:12:52 GMT https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370278#M133339 Anonymous 2013-08-20T11:12:52Z Re: How to shift a column header names into row values https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370279#M133340 Thanks alot.. Its working fine.<BR />Regards,<BR />Karthik Tue, 20 Aug 2013 12:34:17 GMT https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370279#M133340 Anonymous 2013-08-20T12:34:17Z Re: How to shift a column header names into row values https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370280#M133341 Hi, <BR />It is welcome to post your issue on forum.<BR />Best regards<BR />Sabrina Wed, 21 Aug 2013 06:24:21 GMT https://community.qlik.com/t5/Talend-Studio/How-to-shift-a-column-header-names-into-row-values/m-p/2370280#M133341 Anonymous 2013-08-21T06:24:21Z