Pivot Data in Qlik Load Script - Qlik Community

Anonymous · ‎2018-02-15

Is there a way to pivot data in Qlik Load Script ?

Sample Data File:

Desired Output:

Name	Jan 2018	Feb 2018	Mar 2018
John	1000	3000
Berry		2000
Claire			2500

zebhashmi · ‎2018-02-15

Yes, can you search for the cross table?

may be this can help you

ahmar811 · ‎2018-02-16

Hi abhay,

Please find you desire output and also, find attached qvw file for more details.

Regards

Ahmar

isingh30 · ‎2018-02-16

Please check below link - You have to apply Generic Load

Thanks.