Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I found the solution for this using ttranspose talend exchange component. It worked for me
I found the solution for this using ttranspose talend exchange component. It worked for me
I am unable to download tTranspose component, any thoughts ?
Can you please share the lnk to download this component, I'm unable to download this.
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
I am looking to transpose rows to column and load it into another DB object (Table)
could you share an example ?
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.
Hi hope this article can help: you have an attached scenario :
https://help.talend.com/r/jomWd_GKqAmTZviwG_oxHQ/x2GUXKMQs_wrCX0kdZDwDg
HI, as I mentioned, it needs to out to table in Database not the CSV file