You can translate the question and the replies:

What is the meaning of the below example and how can we bring it up in denodo ?

pivot ( min([Planned Date]) for [test] in ([sample1], [sample2]) )
14-09-2020 08:07:44 -0400

2 Answers

Hi, I would follow [How to Pivot and Unpivot views]( Knowledge Base Article to implement the pivot transformation over a view in Denodo. **For example:** ``` select <column_name>, min(case WHEN ("test"= 'sample1') THEN "planned Date" ELSE NULL END)as <sample_name1>, min(case WHEN ("test"= 'sample2') THEN "planned Date" ELSE NULL END)as <sample_name2>, . . . . from <view_name> group by <column_name> ``` Alternatively, my datasource supports the PIVOT function, so I created a base view using "[Create from query](" option where I provide the query with the required PIVOT function. Now, when I execute the created base view, the entire query with the pivot function will be delegated to underlying datasource. If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
15-09-2020 23:51:52 -0400
Thank you very much. This really worked
16-09-2020 09:01:38 -0400
You must sign in to add an answer. If you do not have an account, you can register here