https://community.qlik.com/t5/Talend-Studio/Getting-Multiple-Columns-Data-in-to-one-Column/m-p/2204761#M5505 <P>Hi <BR />You have a similar requirement as showed in this <A href="https://community.qlik.com/s/article/ka03p0000006EZhAAM" target="_self">article</A>, but I am sure your situation is more complex, as the number of columns in the source is changing. <BR /><BR />Regards<BR />Shong</P> Thu, 20 Feb 2020 14:56:57 GMT Anonymous 2020-02-20T14:56:57Z https://community.qlik.com/t5/Talend-Studio/Getting-Multiple-Columns-Data-in-to-one-Column/m-p/2204760#M5504 <P>Hello All,</P> <P>I have a scenario where I have a <STRONG>csv file as my source data</STRONG> and I need to load that in to an Oracle Table.</P> <P>Below is how my file looks like.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="111.PNG" style="width: 983px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M96F.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149976iD6DADA4D36CD302E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M96F.png" alt="0683p000009M96F.png" /></span></SPAN></P> <P>Below is the expected output.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="222.PNG" style="width: 803px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M96K.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129425iF170B16948552757/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M96K.png" alt="0683p000009M96K.png" /></span></SPAN></P> <P>The first three columns in the source file Survey ID, Student, Term are Standard columns in the source but the rest of the columns will change. For example, today there may be three columns for questions and three columns for answers, but the next day the new file may contain more questions and answers.</P> <P>&nbsp;</P> <P>Please help me on how to achieve this scenario.</P> <P>&nbsp;</P> <P>Thank You.</P> Sat, 16 Nov 2024 03:14:50 GMT https://community.qlik.com/t5/Talend-Studio/Getting-Multiple-Columns-Data-in-to-one-Column/m-p/2204760#M5504 DEV4 2024-11-16T03:14:50Z https://community.qlik.com/t5/Talend-Studio/Getting-Multiple-Columns-Data-in-to-one-Column/m-p/2204761#M5505 <P>Hi <BR />You have a similar requirement as showed in this <A href="https://community.qlik.com/s/article/ka03p0000006EZhAAM" target="_self">article</A>, but I am sure your situation is more complex, as the number of columns in the source is changing. <BR /><BR />Regards<BR />Shong</P> Thu, 20 Feb 2020 14:56:57 GMT https://community.qlik.com/t5/Talend-Studio/Getting-Multiple-Columns-Data-in-to-one-Column/m-p/2204761#M5505 Anonymous 2020-02-20T14:56:57Z