You can translate the question and the replies:

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
user
16-08-2023 18:33:21 -0400
code

1 Answer

Hi, Based on the documentation you shared, Denodo has a similar **unpivotregister** function in the [Denodo XtraFuncs for VDP](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20XtraFuncs%20-%20User%20Manual#h.fcztfxfhg97q). This function uses compound data type register to perform unpivot transformations. If you have a valid support user account, you can download and install this from *Denodo Support > Downloads > DenodoConnects*. Alternatively, you can also perform unpivot transformations without the Denodo XtraFuncs for VDP by creating a UNION view through VQL, or by creating the same using Denodo's GUI. For more details, I suggest to checkout this [Knowledge Base article](https://community.denodo.com/kb/en/view/document/How%20to%20Pivot%20and%20Unpivot%20views) on the steps on how to pivot and unpivot Denodo views. Hope it helps!
Denodo Team
17-08-2023 21:41:53 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here