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

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