https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374471#M137064 <P>I have a source table in Oracle having data stored at Column and value in vertical manner. In other word, for a given key, 200 rows with 3 columns , but ultimately means, it has only one row with 200 columns, I need to pivot these rows to column and stored in destination table.</P> Fri, 02 Jul 2021 07:49:03 GMT kotvir 2021-07-02T07:49:03Z https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374464#M137057 <P>Hello Guys,</P><P>Need your help in fixing this scenario, where i have data is stored as key value pairs vertically, I want to transpose this data in talend as columns and rows. for ex:</P><P>my data is like this:</P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p000009IJVMAA4.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148713iC4240576B06F1F78/image-size/large?v=v2&amp;px=999" role="button" title="0693p000009IJVMAA4.png" alt="0693p000009IJVMAA4.png" /></span></P><P>I want to transpose this in talend as below:</P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p000009IJX3AAO.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143444i9560BE2A7A13AF40/image-size/large?v=v2&amp;px=999" role="button" title="0693p000009IJX3AAO.png" alt="0693p000009IJX3AAO.png" /></span></P><P>Please help.</P> Sat, 16 Nov 2024 01:42:16 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374464#M137057 vikramk 2024-11-16T01:42:16Z https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374465#M137058 <P>I found the solution for this using ttranspose talend exchange component. It worked for me</P> Thu, 17 Sep 2020 10:16:30 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374465#M137058 vikramk 2020-09-17T10:16:30Z https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374466#M137059 <P>I am unable to download tTranspose&nbsp;component, any thoughts ?</P> Wed, 30 Jun 2021 03:04:17 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374466#M137059 kotvir 2021-06-30T03:04:17Z https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374467#M137060 <P>Can you please share the lnk to download this component, I'm unable to download this.</P> Fri, 02 Jul 2021 02:26:25 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374467#M137060 kotvir 2021-07-02T02:26:25Z https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374468#M137061 <P>Hi @Viral Kothari​&nbsp;could you express your need with more details ?</P><P>Maybe for your case you just need component like TPivot .</P><P>Send me Love and Kudos</P> Fri, 02 Jul 2021 06:29:46 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374468#M137061 gjeremy1617088143 2021-07-02T06:29:46Z https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374469#M137062 <P>I am looking to transpose rows to column and load it into another DB object (Table)</P> Fri, 02 Jul 2021 07:08:17 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374469#M137062 kotvir 2021-07-02T07:08:17Z https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374470#M137063 <P>could you share an example ?</P> Fri, 02 Jul 2021 07:21:02 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374470#M137063 gjeremy1617088143 2021-07-02T07:21:02Z https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374471#M137064 <P>I have a source table in Oracle having data stored at Column and value in vertical manner. In other word, for a given key, 200 rows with 3 columns , but ultimately means, it has only one row with 200 columns, I need to pivot these rows to column and stored in destination table.</P> Fri, 02 Jul 2021 07:49:03 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374471#M137064 kotvir 2021-07-02T07:49:03Z https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374472#M137065 <P>Hi hope this article can help: you have an attached scenario :</P><P><A href="https://help.talend.com/r/jomWd_GKqAmTZviwG_oxHQ/x2GUXKMQs_wrCX0kdZDwDg" alt="https://help.talend.com/r/jomWd_GKqAmTZviwG_oxHQ/x2GUXKMQs_wrCX0kdZDwDg" target="_blank">https://help.talend.com/r/jomWd_GKqAmTZviwG_oxHQ/x2GUXKMQs_wrCX0kdZDwDg</A></P> Fri, 02 Jul 2021 07:52:45 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374472#M137065 gjeremy1617088143 2021-07-02T07:52:45Z https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374473#M137066 <P>HI, as I mentioned, it needs to out to table in Database not the CSV file</P> Fri, 02 Jul 2021 10:42:16 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transpose-the-data-in-talend/m-p/2374473#M137066 kotvir 2021-07-02T10:42:16Z