topic Re: using match and wildmatch for a expression (Nested if syntax) in App Development

using match and wildmatch for a expression (Nested if syntax)

ajit_aarya — Fri, 01 Jul 2022 13:34:32 GMT

state	names	location
CA	John
OR	james
AZ	Alexis
CA	Matys
OR	AJ
CA	Steve
CA	Hanes

I want location from states CA and OR whose name is ends with ____S and ___N

= If(match(State,'CA','OR', and (WildMatch(name,'????S,'???N')), location))

I tried this

Re: using match and wildmatch for a expression (Nested if syntax)

sidhiq91 — Fri, 01 Jul 2022 13:59:56 GMT

@ajit_aarya Please see below and it resolves your issue then like and accept as solution.

NoConcatenate
Temp:
Load *
where not isnull(Location);

Load *,
if(match(state,'CA','OR') and wildmatch(names,'*s','*n'),state)as Location;

Load * Inline [
state,names
CA, John
OR, james
AZ, Alexis
CA, Matys
OR, AJ
CA, Steve
CA, Hanes

];

Exit Script;

Re: using match and wildmatch for a expression (Nested if syntax)

ajit_aarya — Fri, 01 Jul 2022 14:07:32 GMT

Data already exists , I just need the syntax to perform in chart, i just want to fetch the specified values in different fields to locate.

And another question can we label the expression ??

For example, If(match( State,'CA','OR','WA'),state) can i name or label as west region in the syntax??

Re: using match and wildmatch for a expression (Nested if syntax)

sidhiq91 — Fri, 01 Jul 2022 14:45:39 GMT

@ajit_aarya Regarding your first question, I am not able to understand very clearly. Could you please elaborate or provide some sample on input and expected output.

For 2nd question, you can definitely label the Dimension as 'west region'.