Forum Discussion
sort unpivot attributes by question order
Hello, I am dealing with survey data (Questions and Answers). My particular problem is sorting the questions in order after unpivoting. When I unpivot all the questions they get placed in a new ...
I figured it out. The values quere different from each other in the relational table and that is why ti wasn't working.
Thanks for the help!
v-lili6-msft Thanks for the suggestion.
I have created an index column and attempted to sort by that order but it doesn't work as intended. What it does it assigns a duplicate numbers to the answer rows and that is making the order wrong. I also tried to use the related table with just the answers and a index column and that does not work ether. Any other ideas?
Here is how the data is being ordered:
Thanks again.
I figured it out. The values quere different from each other in the relational table and that is why ti wasn't working.
Thanks for the help!