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 08-10-2021 06:19:33 -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: 8

Dynamic Pivot

Pivot rows into columns in an array
answered 01-10-2021 02:09:00 -0400

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

Answers: 3

Denodo 7.0 ARRAY Pivot

I do not have a finite number of values to include "cases" on to create new columns
answered 16-08-2021 11:08:24 -0400

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

Answers: 2
Related to: https://community.denodo.com/kb/en/view/document/How to Pivot and Unpivot views

Register pivot crosstab

pivot dynamically based on values?
answered 08-04-2021 02:21:52 -0400

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

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

pivot crosstab

combine rows
answered 10-11-2020 05:30:09 -0500

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

Answers: 1

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