Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My field is CustomerType.
I want to transform the field so that if CustomerType IS NOT Equal to a value then name it something else.
I tried the following structure but am not receiving expected results. Am I using an incorrect operator?
IF(CustomerType <> 'Broker' or 'Reseller' or 'House' or 'Player' or 'Sponsor' or 'Employee', 'Personal',
IF(CustomerType = 'Broker' or 'Reseller', 'Reseller')) AS CustomerTypeNew,
May be this
If(not Match(CustomerType, 'Broker', 'Reseller', 'House', 'Player', 'Sponsor', 'Employee'), 'Personal', If(Match(CustomerType, 'Broker', 'Reseller'), 'Reseller')) as CustomerTypeNew,
May be this
If(not Match(CustomerType, 'Broker', 'Reseller', 'House', 'Player', 'Sponsor', 'Employee'), 'Personal', If(Match(CustomerType, 'Broker', 'Reseller'), 'Reseller')) as CustomerTypeNew,