topic Re: Compose new Columns From Fixed Number of Types in Talend Studio https://community.qlik.com/t5/Talend-Studio/Compose-new-Columns-From-Fixed-Number-of-Types/m-p/2313219#M84095 you first have to split female and male before merge results Tue, 26 Jun 2018 08:13:48 GMT fdenis 2018-06-26T08:13:48Z Compose new Columns From Fixed Number of Types https://community.qlik.com/t5/Talend-Studio/Compose-new-Columns-From-Fixed-Number-of-Types/m-p/2313218#M84094 <P>Hey all,</P> <P>&nbsp;</P> <P>I want to convert the following csv-file.</P> <P>&nbsp;</P> <PRE>COUNTRY,CODE,SEX,TIME,VALUE Czech Republic,CZ,Female,2011,5326794 Czech Republic,CZ,Male,2011,5109766 Czech Republic,CZ,Total,2011,10436560</PRE> <P>in order to obtain the following</P> <PRE>COUNTRY,CODE,TIME,Female_Value,Total_Value,Male_Value Czech Republic,CZ,2011,5326794,10436560,5109766</PRE> <P>Hence, I want to flatten the schema based on a fixed number of specific types (here "Male", "Female" and "Total").</P> <P>Could anyone help me? I tried to perform a Self-Join with the tJoin component but it did not work in the desired way.<BR />Thank you very much.</P> <P>&nbsp;</P> Mon, 25 Jun 2018 15:50:56 GMT https://community.qlik.com/t5/Talend-Studio/Compose-new-Columns-From-Fixed-Number-of-Types/m-p/2313218#M84094 Anonymous 2018-06-25T15:50:56Z Re: Compose new Columns From Fixed Number of Types https://community.qlik.com/t5/Talend-Studio/Compose-new-Columns-From-Fixed-Number-of-Types/m-p/2313219#M84095 you first have to split female and male before merge results Tue, 26 Jun 2018 08:13:48 GMT https://community.qlik.com/t5/Talend-Studio/Compose-new-Columns-From-Fixed-Number-of-Types/m-p/2313219#M84095 fdenis 2018-06-26T08:13:48Z