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!