You can translate the question and the replies:

How to apply a check condition in denodo?

Like If I have date_to and date_from I want my date_to should always greater then or equal to date_from not less then. Then how I should Implement this in denodo view.
user
13-03-2015 10:19:00 -0400
code

1 Answer

Hi, Denodo provides a CASE clause, that provides an if-then-else type of logic. You can find all the information about this clause in section 5.12 of the Advanced VQL Guide (https://community.denodo.com/docs/view/document/Virtual%20DataPort/Denodo%205.5/Advanced%20VQL%20Guide). Basically, you just need to edit your view, go to the Output tab, and click on the edit icon of the corresponding attribute (lets say date_to), or just add a new one, and type the following field expression: CASE WHEN (date_to < date_from) THEN date_from ELSE date_to END Hope this helps.
Denodo Team
16-03-2015 07:20:28 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here