Latest Activity

code

Pivoting a column to a row with example

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

unpivot Pivot

code

How to do the columns to row level convert in Denodo?

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

unpivot piviot

code

Table.UnpivotOtherColumns - Denodo Equivalent

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.

unpivot

code

unpivotregister(record) function

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.

unpivot XtraFuncs

code

VQL Functionality Enhancements for UNPIVOTING multiple columns (UNPIVOT in Oracle, CROSS APPLY in SQL Server)

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

VQL unpivot cross apply

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