You can translate the question and the replies:

Pivot function in denodo

Is there any pivot functions in denodo, like the MSSQL server? The KB shows us doing it using case statements. Also is there a new way of creating dynamic columns from distinct row values other than what suggested in below link? https://community.denodo.com/answers/question/details?questionId=90670000000CdG6AAK&title=Dynamic+column+names+generated+from+a+pivot
user
20-04-2020 08:35:02 -0400
code

1 Answer

Hi, I was able to choose any of the following options to do this transformation, as currently PIVOT/UNPIVOT, are not supported in Denodo: 1. As you mentioned, you can use the Knowledge Base article that goes over [How to Pivot and Unpivot Views](https://community.denodo.com/kb/view/document/How%20to%20Pivot%20and%20Unpivot%20views?category=Combining+Data) using CASE statements 2. Write a stored procedure to dynamically generate the column names. Check out the [Developing Stored Procedures](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/developing_extensions/developing_stored_procedures/developing_stored_procedures) section in the Virtual DataPort Developer Guide for more information about creating stored procedures 3. Create the base view from a query. This would have to be done with an underlying database that supports PIVOT/UNPIVOT operations. Denodo would delegate these operations on top of the view to the source Hope this helps.
Denodo Team
20-04-2020 17:34:20 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here