I have a view called "marketplace"
Fields: id, name and value
I would like to put the id in rows, name in columns and values in the row or column for that id and name.
id Name Value 001 ABC 123 002 ABC 123 001 BCD 123
Id ABC BCD 001 123 002...
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 t...