Usage of case statement

Technical queries
, ,
#1

Hello Helical Team,

I am using helical insight EE version 5.0. I would like to use a case statement wherein if the value is something then show something else etc. How can something like that be done?

Thank You,
Netta.

#2

Hello Netta,

We can always do that using custom column. Below is a sample example of how to do that. This can be modified as per requirement.

(Case
When "travel_details"."destination"='Mumbai' then 'High'
When "travel_details"."destination" = 'Lucknow' then 'abc'
Else
'very low'
End
)

NOTE: This syntax might change based on the db that you are using. This above example will work for apache derby, postgress. Based on the db you are using please google and see how the SQL looks like for the case statement of your db and accordingly make the changes like tilde, double quote etc.

Thank You,
Helical Insight.