How to handle CSV file with multiple headers

[kvinoth19991]

Hi Team ,

I'm having a csv with 2 headers , I need to group first header and change the second header to row like below example

Sample :

Input file with 2 headers :

 

Expected Output :

 

How can i achieve it ? i tried transpose and pivot options in Talend & also in SQL. 

Thanks in advance .

Regards,

Vinoth Kumar K.

[David_Beaty]

I think you might find theres a tUnpivot component on Talend Marketplace that does this

Thanks

David