How can i pivot my question data?

[thymenkristen]

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!

[sunny_talwar]

Use The Crosstable Load

[MindaugasBacius · Accepted solution]

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);

[thymenkristen]

Thanks!