You can translate the question and the replies:

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 UNPIVOT or CROSS APPLY functionality within VQL dates back to January 2019 and involves a less-than-elegant approach of stacking multiple UNION statements on top of each other in order to achieve the desired result. This solution can prove to be quite messy from a reading and maintenance standpoint when the underlying source(s) change and/or there are numerous columns that require unpacking into separate rows. https://community.denodo.com/kb/view/document/How%20to%20Pivot%20and%20Unpivot%20views?category=Combining+Data https://community.denodo.com/answers/question/details?questionId=9060g000000fzrDAAQ&title=VQL+support+for+CROSS+APPLY Are there any updated solutions or roadmap items on the radar to address this challenge syntactically in VQL for a cleaner solution? If not, could that please be researched as a potential enhancement? Thanks and Best Regards
VQL unpivot cross apply
user
24-03-2020 14:40:31 -0400
code

3 Answers

Hi, I think for Pivot and Unpivot support in Denodo, you can take a look at this KB article: [How to Pivot and Unpivot views](https://community.denodo.com/kb/view/document/How%20to%20Pivot%20and%20Unpivot%20views?category=Combining+Data). Additionally, if you would like to register an enhancement to add these functionalities directly in future updates of Denodo, you can open a Support Case and request this enhancement. Hope this helps!
Denodo Team
30-03-2020 11:50:34 -0400
code
Hi Did you request this as an enhancement and did you get any further information about apply fron Denodo? Regards
user
17-03-2021 11:34:51 -0400
Hi, If I understand correctly, you are looking for a function that performs pivot/unpivot. If that is the case and you are a valid support user, you could download the Denodo XtraFuncs from the Support Site by navigating to [Downloads > DenodoConnect](https://support.denodo.com/resources/denodo-connect/list/Denodo%208.0). You can take a look at the [Denodo XtraFuncs - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20XtraFuncs%20-%20User%20Manual#h.fcztfxfhg97q) for more information. Further, if want any enhancement and if you are a valid support user then you can raise a support case on [Denodo Support Site](https://support.denodo.com/) so that our support team can help you. Hope this helps!
Denodo Team
01-04-2021 08:46:28 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here