how to transpose the data in talend

[vikramk]

Hello Guys,

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:

my data is like this:

I want to transpose this in talend as below:

Please help.

[vikramk · Accepted solution]

I found the solution for this using ttranspose talend exchange component. It worked for me

[kotvir]

I am unable to download tTranspose component, any thoughts ?

[kotvir]

Can you please share the lnk to download this component, I'm unable to download this.

[gjeremy1617088143]

Hi @Viral Kothari​ could you express your need with more details ?

Maybe for your case you just need component like TPivot .

Send me Love and Kudos

[kotvir]

I am looking to transpose rows to column and load it into another DB object (Table)

[gjeremy1617088143]

could you share an example ?

[kotvir]

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.

[gjeremy1617088143]

Hi hope this article can help: you have an attached scenario :

https://help.talend.com/r/jomWd_GKqAmTZviwG_oxHQ/x2GUXKMQs_wrCX0kdZDwDg

[kotvir]

HI, as I mentioned, it needs to out to table in Database not the CSV file