I want to convert the following csv-file.
COUNTRY,CODE,SEX,TIME,VALUE Czech Republic,CZ,Female,2011,5326794 Czech Republic,CZ,Male,2011,5109766 Czech Republic,CZ,Total,2011,10436560
in order to obtain the following
COUNTRY,CODE,TIME,Female_Value,Total_Value,Male_Value Czech Republic,CZ,2011,5326794,10436560,5109766
Hence, I want to flatten the schema based on a fixed number of specific types (here "Male", "Female" and "Total").
Could anyone help me? I tried to perform a Self-Join with the tJoin component but it did not work in the desired way.
Thank you very much.
Solved! Go to Solution.
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.