Discussion Board for collaboration on QlikView Scripting.
Hopefully soemone can help me with this puzzle.
I want to load a questionnaire and I have the following input file.
Also I have a referential file
Now I would like to create the following structure
Where I can link the UKEY to a table with company/country info.
How can I do this easily. Note the number of questions is like a 1000.
For some reason the transpose function doesn't work as I want it to work.
I´ve Created a source file with your data (Quest.xls) and used it to obtain the desired table. You can do it with CrossTable (it has an assistant to do it. It´s a Transformation Step)
Please se below the script:
LOAD [Question Code],
(ooxml, embedded labels, table is [Referential file]);
CrossTable([Question Code], Answer, 2)
(ooxml, embedded labels, table is Quest);
-- If you have Endless questions, you can use * instead of field names. Hope this helps.