Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    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! 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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! 

  • Kripesh's avatar
    Kripesh
    Frequent Visitor
    7 years ago

    What did you do to sort the mixed data types? Could you please state the solution? I am having the same issue here.