Showing results for 
Search instead for 
Did you mean: 

how to use in() in HANA studio sps6?

Former Member
0 Kudos

hey Guys,

as a rookie of Hana studio, can anybody advise how to use in() in a calculated column in Misc function, example as below:

if( "ZEXO" = 'X','1','0') AND ("ZTYPE"  in ('01','03') );

it's an invalid expression. 

I tried the help doc, but only finding SQL referrence, instead of this function.

wishing guru pops up!


View Entire Topic
Former Member
0 Kudos

Hi guys,

thanks to god, i found it in help ultimately.

the expression should be  in(arg1,...), arg1 =  any of remaining, it's true; else false.

ex: in ("ZTYPE",'01' ,'03')