Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Membership field has value = 'NOT PROVIDED','LOW ENTRY', 'Gold','Diamond', 'Silver','Cooper',
I want to two value in one, like silver and cooper as silver and rest as usual , bellow is the syntax needed to be update
If(Upper([Membership])='NOT PROVIDED','LOW ENTRY',
Upper([Membership])) as [Membership],
May be this?
If(Match(Upper(Membership), 'SILVER', 'COOPER'), 'silver', 'usual') as NewFieldName
May be this?
If(Match(Upper(Membership), 'SILVER', 'COOPER'), 'silver', 'usual') as NewFieldName