Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
May be this:
If(Match(FieldName, 'a', 'b'), 'OK', 'Non-Ok) as NewFieldName
If(Match(FieldName,'a','b'),'OK','Non-OK') as Flag
if (value='a') or (value='b'),'OK', 'Non-Ok' as newField
or
if (match(value,'a','b') > 0, 'OK', 'Non-Ok' as newField
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,
thanks sunny its working if i give wildmacth in the expression
Hi,
Wildmatch() is not case sensitive
where match() is case sensitive
For details search in Help menu.
REgards
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
yes what u said is right i'm grouping a,A