topic Re: How can i pivot my question data? in QlikView

How can i pivot my question data?

thymenkristen — Fri, 08 Feb 2019 11:06:08 GMT

Hi Qlik community,

I'm trying to connect Survey Data in order to analyze it by using Qlikview.

Currently my script is looking like this:

Directory;
LOAD respondent_id,
Q1,
Q2,
Q3,
Q4,
Q5
FROM
Testdata.xlsx
(ooxml, embedded labels, table is Responses2);

Directory;
LOAD respondent_id,
[Vul hier deb_key in:],
[Mag ik u telefonisch een aantal vragen over uw ervaring met Wiltec stellen?],
[Hoe lang bent u al klant bij ons?],
[Wat is uw algemene tevredenheid over Wiltec],
[Hoe waarschijnlijk is het dat u Wiltec aanbeveelt aan vrienden of collega's?]
FROM
Testdata.xlsx
(ooxml, embedded labels, table is [Demographic information]);

Directory;
LOAD QuestionID,
Categorie,
Vraag
FROM
Testdata.xlsx
(ooxml, embedded labels, table is [Question Metadata]);

I want to Pivot my Q1, Q2 etc. and rename it to QuestionID so i Can connect it to my Question Metadata.

But i have no idea how?

Thanks in advance!

Re: How can i pivot my question data?

sunny_talwar — Fri, 08 Feb 2019 14:31:50 GMT

Use The Crosstable Load

Re: How can i pivot my question data?

MindaugasBacius — Fri, 08 Feb 2019 14:35:06 GMT

Try to use crosstable like:

Directory;
CrossTable(QuestionID, Data)
LOAD respondent_id, 
     Q1, 
     Q2, 
     Q3, 
     Q4, 
     Q5
FROM
Testdata.xlsx
(ooxml, embedded labels, table is Responses2);

Instead of using:

Directory;
LOAD respondent_id,
Q1,
Q2,
Q3,
Q4,
Q5
FROM
Testdata.xlsx
(ooxml, embedded labels, table is Responses2);

Re: How can i pivot my question data?

thymenkristen — Fri, 08 Feb 2019 15:14:08 GMT

Thanks!