where clause with if condition (script attached)

[joioan]

Hello, wishes for  a happy new year!

Question.

Does a where clause like that work?

where Key>

if(Field='123' ,2001*12,

if(match(Field,'456','789','101112'),2002*12,

if(match(Field,'131415','161718','192021'),2003*12,

if(match(Field,'222324,'252627') ,2004*12,

if(match(Field,'282930') ,2005*12))))) ;

[Ahidhar]

I don't think it will work better to have if statements before where clause

[Aditya_Chitale]

the if() condition that you have included have multiple outputs thus the where clause won't have a fixed value to compare the "Key" field with and restrict data accordingly.

Create a new field in table script and use this field to compare with Key field and allocate Flags on basis of that and use this Flag in where condition.

Refer below screenshot for script and output:

Output:

Regards,

Aditya