You can translate the question and the replies:

how to do the transpose columns to rows as two separate columns

Hi All, I have to do transpose data columns to rows like below currently data is showing like this: ID date Q1 Q2 1 01-03-2020 00:00 6 9 2 13-03-2020 00:00 7 8 Expected output: ID date Questions Answers 1 01-03-2020 00:00 Q1 6 2 01-03-2020 00:00 Q1 7 1 01-03-2020 00:00 Q2 9 2 01-03-2020 00:00 Q2 8 kindly help me how to do the transpose. Regards,
user
09-06-2020 10:13:33 -0400

1 Answer

Hi You could refer to the section ***UNPIVOT*** in the knowledge base article [How to Pivot and Unpivot views]( https://community.denodo.com/kb/view/document/How%20to%20Pivot%20and%20Unpivot%20views?category=Combining+Data) to transform columns to a row. Hope this helps!
Denodo Team
10-06-2020 04:27:10 -0400
You must sign in to add an answer. If you do not have an account, you can register here