Forum Discussion
Conditional Column - Survey Ratings
Referring to your reply to me further up.
Are the 3 new columns populated correctly?
If so, what is the desired result from the example data in the screenshot (this hasn't been defined yet - only that some results are wrong)? i.e. what should the 4th new column show. Please show it as an example.
Hi HotChilli,
Yes the 3 conditional columns are populated correctly. I'm expecting the final result to be in the following format after unpivoting with the responses classified correctly for each survey question i.e. Agree and Strongly Agree should be classified as Agree/Strongly Agree and the rest of the responses should be classified as Others. For example, in the following table, the Agree was classified as Others for the question Overall Positive Experience and Recommend My Colleagues which were incorrect. It should have been classified as Agree/Strongly Agree. Hope that clarifies. Otherwise do let me know again, thanks!
Hi HotChilli,
I managed to find out the solution as I was trying out the conditional columns again. So instead of adding the unconditional column first then unpivot, I should have unpivot then add the unconditional column to reclassify the responses. Problem solved. Thanks everyone for your inputs, though you didn't directly solve my problem but your responses have somehow helped me to find the way out myself. I have new question now on the filtering will ask in a separate thread.
