how to use in() in HANA studio sps6?

[Former Member]

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!

J

[Former Member · Accepted solution]

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')