I've a CSV file in he below format
I need it in below format
Is there any way to achieve this using the Data Integration tool?
Sorry, I read your post too fast!
In this case, your friend is tSplitRow.
Here is the job design, the tSplitRow settings and the according schema:
The issue here is I have a .csv file. I need to perform the above operation in that file. I think tFixedFlowInput is not suitable for reading from a file. Am I correct?
Your answer is correct. But in my case, my file contains about 60 headers and 1000s od data. So it's practically not feasible to map all the columns in the above mentioned way. And I like to have a generic method so that any CSV file in the above format but with different header names should also be processed.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.