Script not working

[nareshthavidishetty]

hi all,

i got a requirement there are some values as (a,b,c,d,e,f,g)

where a,b should be OK and rest as Non-Ok

need to create a field with values OK and Non-Ok

[sunny_talwar]

May be this:

If(Match(FieldName, 'a', 'b'), 'OK', 'Non-Ok) as NewFieldName

[MK_QSL]

If(Match(FieldName,'a','b'),'OK','Non-OK') as Flag

[Anonymous]

if (value='a') or (value='b'),'OK', 'Non-Ok' as newField

or

if (match(value,'a','b') > 0, 'OK', 'Non-Ok' as newField

[PrashantSangle · Accepted solution]

Hi,

Create Flag in back end.

Like

if(wildmatch(FieldName,'a','b'),'OK','Non - OK') as Flag;

Note: You can use match() or wildmatch() as per requirement.

Regards,

[nareshthavidishetty]

thanks sunny its working if i give wildmacth in the expression

[PrashantSangle]

Hi,

Wildmatch() is not case sensitive

where match() is case sensitive

For details search in Help menu.

REgards

[sunny_talwar]

I guess than use WildMatch if Fieldname can have 'a' and 'A' and both needs to be grouped as OK or you can do this:

If(Match(Lower(FieldName), 'a', 'b'), 'OK', 'Non-Ok) as NewFieldName

[nareshthavidishetty]

yes what u said is right i'm grouping a,A