Transpose a 2 column table from excel into DB

nivedhitha — Thu, 31 Jan 2019 16:44:46 GMT

Hi everyone,

Im trying to transpose the below table from an excel file

No headers for the table.

I have to transpose it and load it to a table like this

I downloaded the custom component tTranspose and used it to transpose but what im not sure is how to define the schema in Transpose and get the proper headers in DB. Whatever schema is defined in the transpose component is taken as the header and the first column from the source is part of the data.

With the schema defined as follows in transpose

The output in tlogfile is

But the 1st record should be the header.

Can someone help me out ?

Thanks in advance

Re: Transpose a 2 column table from excel into DB

dipanjan93 — Thu, 31 Jan 2019 16:58:36 GMT

You could use the logic from my post below -

https://community.talend.com/t5/Design-and-Development/Transpose-rows-to-columns/m-p/134959#M84121

topic Re: Transpose a 2 column table from excel into DB in Talend Studio

Transpose a 2 column table from excel into DB

Re: Transpose a 2 column table from excel into DB