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

1 Answer

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
You must sign in to add an answer. If you do not have an account, you can register here