Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Compose new Columns From Fixed Number of Types

Hey all,

 

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.

 

Labels (2)
1 Solution

Accepted Solutions
fdenis
Master
Master

you first have to split female and male before merge results

View solution in original post

1 Reply
fdenis
Master
Master

you first have to split female and male before merge results