You can translate the question and the replies:

Pivoting a column to a row with example

I have a view with two columns as shown below: Label | Value ------------------- Name | John Age | 29 Sex | M Name | Amy Age | 46 Sex | F It goes on and on like this. What I want is this: Name | Age | Sex -------------------------- John | 29 | M Amy | 46 | F But am having trouble with this. What would the VQL query be to accomplish this?
Pivot unpivot
user
10-01-2024 09:47:19 -0500
code

1 Answer

Hi, To learn how to pivot views, refer to [How to Pivot and Unpivot views](https://community.denodo.com/kb/en/view/document/How%20to%20Pivot%20and%20Unpivot%20views) in the Knowledge Base. In this case, I would follow the example involving key-value pairs at the bottom of the "1. Pivot" section, since it is very similar to the situation posed in this question. Hope this helps!
Denodo Team
11-01-2024 17:03:15 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here