Discussion Board for collaboration related to QlikView App Development.
I have table like this:
From [CSVFILES.CSV] ();
The fields Questionx (like this: You have a car?), is a simple anwser (Yes/No)
I must "transform" the fields named "Questionx" to Question and renamed field Questionx to anwser.
I try someting like this:
1) I Create a map table from Question LOAD * INLINE [QuestionId, Question ....];
2) LET = QuestionId = 0;
FOR EACH vQuestion In $(vQuestions)
LET = QuestionId = QuestionId + 1;
$(QuestionId) as QuestionId,
FieldValue(FieldName(FieldNumber('$(vQuestion )', 'BASE'), 'BASE'), RowNo()) as Anwser
WHERE FieldName(FieldNumber('$(vQuestion )', 'BASE'), 'BASE') = '$(vQuestion)'
But, The anwser field return null.
can anyone help me?
Go to Solution.
If the questions is the field-name then you could transform it with crosstable:
View solution in original post
You want rename a field then you could use the rename-statement(s) - have a look in help.
Unfortunately its proposal will not work, I have many question fields to treatment individually.
If I look on your load-statement you might need to load your data with a crosstable-statement to transform your crosstable into a data-stream.
Marcus this information is related to an investigation of these we respond when we are approached by field researchers. Like this:
CSV files bring the same information in the same way, that is, the question is the field name.
What I want is to create a new table with a QuestionID field where I can identify what's the question (1, 2, 3 etc) and this answer.
I have a table where the questions are mapped.
An example of the table is: