I have a problem. I want to replace the text of 'Answer' to numbers (1,2,3,4) for 6 different questions. The questions all have the same 4 answer alternatives.
This works fine if I only add one of the questions in the load script (see picture 1), then I will get the correct result in my table (see picture 2).
If I add all 6 questions in the loadscript (see picture 3) the table will show strange values (see picture 4). The result is now that each row in the table has now been converted to all numbers (1,2,3,4) and this goes for all 6 questions (I only show one question in the table here).
I would really appreciate your help!
Use as below
Pick(Match(Answer,'Agree','Strongly agree','Disagree','Strongly disagree'),2,1,3,4) as MasterNumber
Unfortunately I'm not allowed to send out the file since the appliation contains confidential information.
Is there any other specific information I can give you?
you can scramble your data in 'document properties / scrambling'
By match, your cross 2 fields (QuestionId X ResponseId) and get a result like a join would provide