This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!
Hi,
I have a a colonne with differents code to exclude the next code:
I test this code, but i have errors :
if(WildMatch(CODE,'*5','*5A'),CODE,
if(Not WildMatch(CODE,'*603*'),CODE,NULL())
if (CODE > 401231,CODE)
)
Thanks in advance
@jmialoundama Are you using QikView or Sense? I would like to move this into the correct product forum.
What is the error message?
You IF syntax is incorrect:
if(WildMatch(CODE,'*5','*5A'),CODE,
if(Not WildMatch(CODE,'*603*'),CODE,NULL())
if (CODE > 401231,CODE)
)
Here is the right syntax (you might want to rearrange the NULL() but basically it is syntax error):
if (WildMatch(CODE,'*5','*5A'),CODE,
if(Not WildMatch(CODE,'*603*'),CODE,
if (CODE> 401231,CODE,NULL())))
Instead of a nested if, how about using OR:
If(WildMatch(CODE,'*5','*5A')
or (Not WildMatch(CODE,'*603*')
or CODE > 401231
,CODE)
-Rob