Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sudhakaran_abha
Contributor

Pivot Data in Qlik Load Script

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

Sample Data File:

NameSalaryMonthYear
John1000Jan 2018
Berry2000Feb 2018
Claire2500Mar 2018
John3000Feb 2018

Desired Output:

NameJan 2018Feb 2018Mar 2018
John10003000
Berry2000
Claire2500
Tags (1)
3 Replies
zebhashmi
Valued Contributor

Re: Pivot Data in Qlik Load Script

Yes, can you search for the cross table?

may be this can help you

Creating a new column in the script

ahmar811
Contributor III

Re: Pivot Data in Qlik Load Script

Hi abhay,

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

Capture.JPG

Regards

Ahmar

isingh30
Valued Contributor

Re: Pivot Data in Qlik Load Script

Please check below link - You have to apply Generic Load

https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

Thanks.