Latest Activity

code

Pivot-xfunct-Denodo 8-pivotregister

Hi, I need to create a pivot from a data view. I have followed the documentation https://community.denodo.com/kb/en/view/document/How%20to%20Pivot%20and%20Unpivot%20views but the solution does not meet my needs. On the other hand, I found a function t...

xfunct pivotregister Pivot

code

Dynamic column names generated from a pivot

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

Dynamic Pivot

code

Pivot rows into columns in an array

Hello, what I would like to achieve could be straightforward but I'm very new to Denodo. I have a view like this: model_id equipment 1 Array where the Array is like this: description v...

Denodo 7.0 ARRAY Pivot

code

I do not have a finite number of values to include "cases" on to create new columns

I have scenario where the number unique values in the column (questionid) could keep getting larger. so I can't set up a static list of CASE conditions is there a way to dynamically take the column value for question id and put it across the top of t...

Related to: How to Pivot and Unpivot views

Register pivot crosstab

code

pivot dynamically based on values?

Is there a way to dynamically create the headers for the pivot based on the values in the data? for example if I have a field that has a mapping type that can either be "sector" or "region" and then have a value by person. and end up with a cross tab t...

Related to: How to Pivot and Unpivot views

pivot crosstab

code

combine rows

I have a table like this ItemNbr Identifier Value 123 plant C01 123 plant C02 123 mrp M01 123 mrp M02 456 mrp M03 I want like this ItemNbr plant mrp 123 C01 M01 123 C02 M02 456 null M03 I tried creating 2 different views based on Identifier column ...

Pivot

code

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

dynamic columns Pivot

code

UNPIVOT et PIVOT

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

Related to: How to Pivot and Unpivot views

unpivot Pivot

code

Pivoting Denodo View Results

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

Denodo 6.0 Pivot custom wrapper View