topic Re: How to pivot/unpivot this dataset in Qlik NPrinting

How to pivot/unpivot this dataset

Nakul — Sat, 16 Nov 2024 04:42:54 GMT

I want to convert my dataset to the following structure, can someone please help me out.

Thanks in advance.

Source:

SURVEY_ID	TREND_ID	ANSWER
101	501	55
101	502	66
101	503	Good
101	504	very Good
102	501	77
102	502	99
102	503	Good
102	504	Good
103	501	77
103	502	66
103	503	Good
103	504	Good

Target state:

SURVEY_ID	501	502	503	504
101	55	66	Good	very Good
102	77	99	Good	Good
103	77	66	Good	Good

Re: How to pivot/unpivot this dataset

michal__ — Sun, 20 Jan 2019 10:18:20 GMT

Take a look at the generic load.

https://help.qlik.com/en-US/sense-cloud/Subsystems/CloudHub/Content/Sense_Hub/Scripting/ScriptPrefixes/Generic.htm

https://help.qlik.com/en-US/sense-cloud/Subsystems/CloudHub/Content/Sense_Hub/DataSource/generic-databases.htm

Re: How to pivot/unpivot this dataset

jonathandienst — Mon, 21 Jan 2019 05:35:04 GMT

There's no need to transform the data in script. Just create a pivot table with SURVEY_ID (row) and TREND_ID (column) as dimensions, and Only(ANSWER) as the expression/measure. In Qlikview, pivot the TREND_ID by dragging it to the top.