HELP: Loss of records when using UNPIVOT

[Anonymous]

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

[richbenmintz]

Hi @Anonymous,

Can you provide the data?

[amitchandak · Accepted solution]

@Anonymous , are there any null/blank values ?

[Anonymous]

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!