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?
20-04-2020 08:35:02 -0400

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]( using CASE statements 2. Write a stored procedure to dynamically generate the column names. Check out the [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
You must sign in to add an answer. If you do not have an account, you can register here