IF Match

[#1]

Hello ,

Can you please point me to the right direction?

I am trying to run below script;

LOAD CATALOG,

IF (match(KITCHEN,BEDROOM, KITCHEN1, KITCHEN2, BEDROOM1));

SQL SELECT *

FROM database.dbo."database_name"

WHERE STATUS<>'XX'

; 

not working, the error message is;

Error in expression:

If takes 2-3 parameters

What I am doing wrong?

Thank you in advance, all little helps 🙂

[tresesco]

The wrong expression part is:

IF (match(KITCHEN,BEDROOM, KITCHEN1, KITCHEN2, BEDROOM1));

If( <cond>, Then do this)  // you are missing this part

Not only that, probably your Match() is not right.

[sivarajs]

you should give field name in match condition

match(fieldname,'string1','string2'...)

You are missing action part in If condition as tresesco mentioned

[#4]

We could help you better if you can post what you're trying to achieve.

[#5]

All sorted out now. Thanks for all the help, much appreciated. Elizabeth