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]( 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
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](** for transforming rows in an array. To use this function, I would download the **Denodo Xtrafuncs for VDP** from the **[Denodo Support site](** 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](** 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!!
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]( 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]( 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