If statement in Script

[evansabres]

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,

[sunny_talwar · Accepted solution]

May be this

If(not Match(CustomerType, 'Broker', 'Reseller', 'House', 'Player', 'Sponsor', 'Employee'), 'Personal', If(Match(CustomerType, 'Broker', 'Reseller'), 'Reseller')) as CustomerTypeNew,