Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if([NCR_TYPE]='RI','Receiving Inspection',[NCR_TYPE]) and if([NCR_TYPE]='IP','In-Process',[NCR_TYPE]) as [Flag],
If you don't use wildcards, you don't need the wildmatch() function. And instead of multiple if() statements, you can use a pick() / match() combination:
pick( match(NCR_TYPE,'RI','IP')+1 //+1 to return 1 for no matching value
,'NULL'
,'Receiving Inspection'
,'In-Process'
)
as [Flag]
What do you get returned? -1 for all records?
And what do you expect as result for different input values?
'Expression not working' is not really helpful to understand your requirement.
Trying to chage the feild value..
I could get using Wildmatch
if
(wildmatch(NCR_TYPE,'RI'),'Receiving Inspection',
if(wildmatch(NCR_TYPE,'IP'),'In-Process',
if(wildmatch(NCR_TYPE,'',' ') or isnull(NCR_TYPE),'NULL'))),
If you don't use wildcards, you don't need the wildmatch() function. And instead of multiple if() statements, you can use a pick() / match() combination:
pick( match(NCR_TYPE,'RI','IP')+1 //+1 to return 1 for no matching value
,'NULL'
,'Receiving Inspection'
,'In-Process'
)
as [Flag]
It worked .Thank you.