You can translate the question and the replies:

Pivot-xfunct-Denodo 8-pivotregister

Hi, I need to create a pivot from a data view. I have followed the documentation https://community.denodo.com/kb/en/view/document/How%20to%20Pivot%20and%20Unpivot%20views but the solution does not meet my needs. On the other hand, I found a function that seems more appropriate to my case which is "pivotregister" but by following the example I get the following error : "'pivotregister' with arity 2 not found" Note that I did not add any extension because I cannot find xfunct-pivot jar on the support site ( I download the denodo-xtrafuncs-vdp-8.0-20200506) so according to the first documentation it's already included in my denodo installation? I use Denodo 8 with the following updates : - 20220815 - 20230301 Thank you,
Pivot xfunct pivotregister
user
21-03-2023 12:37:18 -0400
code

3 Answers

Hi, This error usually occurs when you specify incorrect arguments to the function. I’ve found a similar question about the same error.[ Pivot rows into columns in an array](https://community.denodo.com/answers/question/details?questionId=9064u000000L886AAC&title=Pivot+rows+into+columns+in+an+array). I’d also check [Denodo XtraFuncs - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20XtraFuncs%20-%20User%20Manual#h.fcztfxfhg97q) which explains how to use the PIVOT function. Also, I’ve downloaded from [the Denodo Support Site](https://support.denodo.com/) the latest version of Denodo Xtrafuncs for VDP and 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. Click on Ok and refresh the tool by navigating to "File -> Refresh" for reflecting the changes. Hope this helps!
Denodo Team
22-03-2023 06:03:10 -0400
code
Hi, Where to find the jar you are talking about? I downloaded the "denodo-xtrafuncs-vdp-8.0-20200506-dist" on the support site but there are only 4 jars there : denodo-xtrafuncs-vdp-spatial-8.0-20200506-jar-with-dependencies.jar denodo-xtrafuncs-vdp-encryption-8.0-20200506-jar-with-dependencies.jar denodo-xtrafuncs-vdp-string-8.0-20200506-jar-with-dependencies.jar denodo-xtrafuncs-vdp-date-8.0-20200506-jar-with-dependencies.jar where to find the "denodo-xtrafuncs-vdp-pivot-<version>-jar-with-dependencies.jar" ? Thank you,
user
22-03-2023 08:00:16 -0400
Hi, I've checked [the Denodo Support Site](https://support.denodo.com/) and currently the latest version is 20220922. I'd make sure that I am selecting the correct product version (eg: Denodo 8) in the tabs. Also, in the description of the connector you can check which is the version. Hope this helps!
Denodo Team
24-03-2023 05:21:30 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here