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.
25-09-2020 09:48:43 -0400

1 Answer

Hi, I was able to transform row to column by using the steps mentioned in the [How to Pivot and Unpivot views]( 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](, 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
You must sign in to add an answer. If you do not have an account, you can register here