Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if(match(Category,'4','9','16','21','22')=0,'Trust_Non-Reccuring','Trust Reccuring') as Feetype,
When I run this script I am getting only one value i.e Trust_Non-Reccuring in the field Feetype.Why am I missing Trust Reccuring value from the field ?
Thanks in advance.
Such a question is hard to answer without knowing the values from field Category.
try without = 0
if (match(value, matches), then , else)
Regards
Seems like nothing is matching your values 4,9,16,21,22. I would check your data. Maybe you are looking for a wildmatch?
if(wildmatch(Category,'*4*','*9*','*16','*21*','*22*')=0,'Trust_Non-Reccuring','Trust Reccuring')
But thats just a complete guess.
Hope this helps!
Hi,
Match function returns position number if category values matches with 4','9','16','21','22...not always zero (0).
try this:
if(match(Category,'4','9','16','21','22') > 0,'Trust_Non-Reccuring','Trust Reccuring')
The match function performs a case sensitive comparison.
Example:
match( M, 'Jan','Feb','Mar')
returns 2 if M = Feb
returns 0 if M = Apr or jan