Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
INVITATION:
LOAD * INLINE [
unique_id,batch_id
2334,2
3223,2
];
USERQUESTION:
LOAD * INLINE [
question_id,answer_choiced_id as answerID,unique_id, question type,user_answer
311,2,2334,multiple,
312,1,2334,multiple,
313,0,2334,freeform, I was so sick that i had surgery.
311,4,3223,multiple,
312,5,3223,multiple,
313,0,3223,freeform,i am unemployeed, lost both part time jobs
];
ANSWERTEXT:
LOAD * INLINE [
answer_id as answerID, answertext
2,short on cash
1,too late
4, stuck on bills
5, none above
7, no work
3,late payment
];
My required output
unique_id | multiple question 1 | multiple question 2 | freeform |
---|---|---|---|
2334 | short on cash | too late | I was so sick that i had surgery. |
3223 | stuck on bills | none above | i am unemployeed, lost both part time jobs |
I am using dimensions:
Dimension1 :multiple question 1 (i.e question num 311): if(match(question_id,'311'), answertext)
Dimension2 : multiple question 2 (i.e question num 312): if(match(question_id,'312'), answertext)
Dimension3 : freeform (i.e question num 313): if(match(question_id,'313'),user_answer)
But i am able to view only one question field(that question could be any question which is first put), other questions field shows null.
How could i do this in straight Table?
Hi Supriya R
Please take a look at the apps attached.
I can only created the result through pivot table though, still no luck from normal table.
In the script i do left join for all table to USERQUESTION.
in the Pivot table, in the measure :
if(question_id <> '313',Only(answertext),Only(user_answer))
I'll try to make the straight table version * if i can
Hope it helps though,
Best Regards,
Kevin