Transpose a 2 column table from excel into DB

[nivedhitha]

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

[dipanjan93]

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