You can translate the question and the replies:

Pivot rows into columns in an array

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 | value | | -------- | -------- | | leistung | 150kw | | getriebe | automatik | | reichweite | 150km | the function used for the array is the following: `nest(description, value)` what I want to achieve is the following: | lesitung | getriebe | reichweite | | -------- | -------- | -------- | | 150kw | automatik | 150km | I tried using the function `pivotregister` as shown here: [pivot](https://community.denodo.com/docs/html/document/denodoconnects/7.0/en/Denodo%20XtraFuncs%20-%20User%20Manual#h.fcztfxfhg97q) but I get this error: Function 'pivotregister' with arity 2 not found ``` select in_model_id, pivotregister(equipment, 'getriebe:string,leistung:string,reichweite:string') from view ``` How could achieve such thing? Thanks in advance
user
31-03-2021 10:06:22 -0400

3 Answers

Hi, The error **"Function ‘pivotregister’ with arity 2 not found"** usually occurs when you specify incorrect arguments to the PIVOT function or if the PIVOT function is not available in the Virtual DataPort. The PIVOT function is a **[Denodo Platform Xtra function](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20XtraFuncs%20-%20User%20Manual)** for transforming rows in an array. To use this function, I would download the **Denodo Xtrafuncs for VDP** from the **[Denodo Support site](https://support.denodo.com/resources/denodo-connect/list)** and then import the jar file using the **‘File -> Extensions Management’** option available in the Virtual DataPort Administration Tool. For your scenario, you could follow the steps mentioned in the **[How to Pivot and Unpivot views](https://community.denodo.com/kb/view/document/How%20to%20Pivot%20and%20Unpivot%20views?category=Combining+Data)** Knowledge Base Article which explains in detail with examples on how to transform rows to columns. Hope this helps!
Denodo Team
01-04-2021 08:07:04 -0400
I couldn't find the jar file for pivot or unpivot in Denodo Xtrafuncs for VDP. Is there any specific version to look for on the support site? When i downloaded the Denodo Platform Xtra function i could just see Jars for following : Date Encryption String Spatial Any help would be appreciated!!
user
24-09-2021 13:21:17 -0400
Hi, I was able to successfully download the latest version of Denodo Xtrafuncs for VDP (version: 20210830) from the [support site](https://support.denodo.com/resources/denodo-connect/list/Denodo%208.0#) and it contains all the required jars (Date, Encryption, Pivot, String, Spatial). **Please make sure to download the latest version of xtrafuncs.** To import the JAR files for pivot and unpivot functions, follow the below steps in the Virtual DataPort Administration Tool: * Navigate to "File -> Extension Management". * Click on **Import** and select the required jar files from the **dist** folder of Denodo Xtrafuncs for VDP. The "**denodo-xtrafuncs-vdp-pivot-<version>-jar-with-dependencies.jar**" needs to be imported into the Virtual DataPort server, to use the desired pivot and unpivot Xtrafuncs in the Virtual DataPort Administration Tool. * Click on **Ok** and refresh the tool by navigating to "File -> Refresh" for reflecting the changes. After importing the jar files, you will be able to use the desired pivot functions. For detailed information , you can refer to the [Denodo XtraFuncs - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20XtraFuncs%20-%20User%20Manual) section of the DenodoConnect Components. Hope this helps!
Denodo Team
01-10-2021 02:09:00 -0400
You must sign in to add an answer. If you do not have an account, you can register here