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 :