Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Dear all,
I have a small set of records (total 530) representing a survey. Each record represents an answer, the rest of the columns represent the answers to specific question within the sequence of answer.
In order to visualize the results, I have unpivoted the "question answers", ending up with three columns (AnswerID, Question, Weight of Answer).
My issue is: I start with 530 AnswerIDs and after unpivoting I only have 512 (lost 18 on the way).
Do you have any idea on what I could be doing wrong?
Thanks,
LMA
Solved! Go to Solution.
@Anonymous , are there any null/blank values ?
Hi @Anonymous,
Can you provide the data?
Proud to be a Super User!
Hi @amitchandak - indeed, the blanks were being left out in the pivoting. I worked around it by entering a random value in the blanks, pivoting and then replacing the value again by "null". Thank you!
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |