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.