Q&A BY TAG 'Pivot'

You must sign in to ask a question. If you do not have an account, you can register here

Dynamic column names generated from a pivot
answered 24-04-2020 02:20:09 -0400

Is there a way in Denodo to do a pivot where you generate the column names from a column's distinct values. The only example I could find for Denodo used static values you already knew. I am assuming if there is, it is going to have to be custom VQL q...

Answers: 4

Dynamic Pivot

Pivot function in denodo
answered 20-04-2020 17:34:20 -0400

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.den...

Answers: 1

dynamic columns Pivot

UNPIVOT et PIVOT
answered 19-03-2018 08:08:01 -0400

Bonjour, c'est vraiment dommage que Denodo ne prennent pas en charge les fonctions pivot et unpivot car ces fonctions sont pr├ęsentes dans plusieurs type de BDD sources: Oracle, SQL server, .... en effet, les m├ęthodes de contournement sont fastidieuse...

Answers: 1
Related to: How to Pivot and Unpivot views

unpivot Pivot

Pivoting Denodo View Results
answered 12-03-2018 09:12:32 -0400

I have a SQL server procedure that pivots a table with unknown number of rows and these number of rows can be dynamic and change throughout the day; I have created a view to replace the sql server table but now I need to replicate or replace the stored...

Answers: 1

Denodo 6.0 Pivot custom wrapper View