You can translate the question and the replies:

Case function in Denodo

Hi Team, I have a requirement to implement a scenaion similar to the below in Denodo. But I am not sure, how to go about it using denodo case function. It is throwing me some error. Can you please help? IF [varI] =0 then 'Perm' ELSEIF([varI] >0 and [varI] <=30) then '1-30' ELSEIF ([varI] >30 and [varI] <=60) then '31-60' ELSEIF ([varI] >60 and [varI] <=90) then '61-90' ELSEIF ([varI] >90 and [varI] <=120) then '91-120' ELSEIF [varI] >120 then '>120' END
user
30-05-2019 05:00:47 -0400
code

1 Answer

Hi, You can refer to [CASE Clause Examples](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/case_clause_examples/case_clause_examples#case-clause-examples) of Virtual DataPort VQL Guide, which explains how to use **CASE Clause** in Denodo Platform. Hope this helps!
Denodo Team
31-05-2019 07:54:56 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here