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 team, Does denodo provide the function to do the columns to rows convert? Please refer to belwo table/data example for the transformation we want to do? Let us know how to do it in Denodo side? Thanks. Before: | date | region | book |account |usd_s...
Hello. Does Denodo have a function similar to the Table.UnpivotOtherColumns available in Power BI (https://learn.microsoft.com/en-us/powerquery-m/table-unpivotothercolumns)? Thank you.
Hello. Which extension do I need to import in Extension Mangement to have access to the unpivotregister(record) function in Denodo cloud, please? Thank you.
Hello Denodo Support Team, I understand that Denodo VQL supports TVFs (Table Value Functions) regarding the unpivoting of multiple columns in a view and joining to other sources. However, the most recent proposed solution for addressing the powerful UN...
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