Show different values in table label and output

klikgevoel · ‎2019-04-04

Hi all,

Lets assume I have a table with the following variables: ResultID, Questionnaire, Question and Answer. ResultID is unique, hence a key, and Questionnaire has different entries and the same goes for Question and Answer.

What I want in my app is to show Answer as a dimension in a table, with its label being the Question. However, due to multiple Questions, Answers and Questionnaires I cannot seem to get it to work. That is, I cannot split the Question based on the Questionnaire and its connected Answer.

Below is some arbitrary data to work with.

Surveys:
LOAD * INLINE [
    ResultID, Questionnaire, Question, Answer  

    1-1, AskHim-1, What do you want, Nothing
    1-2, AskHim-2, What do you like, Fries
    1-3, AskHim-3, What do you see, Stuff
    1-4, AskHim-4, What do you feel, Dont know
    2-1, AskHer-1, What do you drink, Tea
    2-2, AskHer-2, What is your favorite show, Oprah
];

LinkSurvey:
LOAD * INLINE [
   ResultID, SurveyResultID
   1-1, 1
   1-2, 2
   1-3, 3
   1-4, 4
   2-1, 5
   2-2, 6
];

Fact:
LOAD * INLINE [
   SurveyResultID, PersonID
   1, 22
   2, 22
   3, 22
   4, 22
   5, 30
   6, 30
];

Thanks in advance

Conditions matching