How to handle CSV file with multiple headers

kvinoth19991 — Fri, 15 Nov 2024 22:08:43 GMT

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.

Re: How to handle CSV file with multiple headers

David_Beaty — Thu, 09 Mar 2023 07:27:45 GMT

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

Thanks

David