Latest Activity
I have a view with two columns as shown below: Label | Value Name | John Age | 29 Sex | M Name | Amy Age | 46 Sex | F It goes on and on like this. What I want is this: Name | Age | Sex John | 29 | M Amy | 46 | F But am having trouble with this. W...
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...
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...
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...
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
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
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 ...
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...
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
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...