You can translate the question and the replies:

Convert rows into columns after flattening in denodo

I have created a base view out of an API which returns me some array rcolumns. I then flattened these columns using flattening function in denodo. But I get multiple rows for a single account. My requirement is to convert these rows in corresponding columns. Could you please help.
user
25-09-2020 09:48:43 -0400
code

1 Answer

Hi, I was able to transform row to column by using the steps mentioned in the [How to Pivot and Unpivot views](https://community.denodo.com/kb/view/document/How%20to%20Pivot%20and%20Unpivot%20views?category=Combining+Data) knowledge base article which explains in detail with examples how to transform rows to columns using graphical interface and also using VQL query. You can also refer to similar Q&A [here](https://community.denodo.com/answers/question/details?questionId=9064u000000CeskAAC&title=What+is+the+meaning+of+the+below+example+and+how+can+we+bring+it+up++in+denodo+%3F), which explains in detail how to use pivot (row to column) in Denodo. Hope this helps!
Denodo Team
29-09-2020 02:05:34 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here