You can translate the question and the replies:

Pivoting data

Hi 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 to Id ABC BCD 001 123 002 123 001 123 Thanks DF
user
06-07-2023 00:32:28 -0400
code

1 Answer

Hi, There are various solutions you can consider to pivot the data in your view. One way is implementing a logic that executes built-in functions like CASE WHEN, MAX, COUNT, etc. You can refer to the knowledge base article [How to Pivot and Unpivot Views](https://community.denodo.com/kb/en/view/document/How%20to%20Pivot%20and%20Unpivot%20views) for a detailed guide on how to do this. Alternatively, you can also pivot the data using Denodo’s extended custom function. You can check the answer in the community question [here](https://community.denodo.com/answers/question/details?questionId=9064u000000L82SAAS&title=pivot%20dynamically%20based%20on%20values%3F), which guides you on how to pivot data using [Denodo Xtrafuncs](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20XtraFuncs%20-%20User%20Manual) for VDP. Hope this helps!
Denodo Team
07-07-2023 03:26:08 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here