topic Re: How to use a wildmatch function inside a Match function in App Development

How to use a wildmatch function inside a Match function

sudms — Wed, 29 Mar 2023 11:38:35 GMT

Hello Guys,

I am trying to replace nested if with Pick Match function, but I am stuck at using Wildmatch inside the Match function like,

pick(
Match( -1,
Subjects = 'Stat',
WildMatch(Name,'YYY*')
)+1
,'NA'
,'Low'
,'High'
)

Here if you see my 2nd condition is not working.

Any help would be appreciated.

Or — Wed, 29 Mar 2023 12:16:51 GMT

Wildmatch() never returns -1. It returns the number of the match, or 0 if no match was found, same as Match().

marcus_sommer — Wed, 29 Mar 2023 13:19:37 GMT

Just add a comparing to the wildmatch(), like:

pick(
Match( -1,
Subjects = 'Stat',
WildMatch(Name,'YYY*') > 0
)+1
,'NA'
,'Low'
,'High'
)