Wildmatch, Wildmatch5 & LIKE function

[#1]

I want to tag a list of account with below query:

if(WildMatch([MAKE & MODEL],'*MOTORC*'),'Motorcycle',

if(REASON_CODE='SKIP','Exclusion List',

if([PRODUCT TYPE]='902' or [PRODUCT TYPE]='903','Floor Stocking',

if([PRODUCT TYPE]='900' or [PRODUCT TYPE]='901',Block Discounting',

if([DISBURSEMENT YEAR]=2013 AND RNR='N' AND [CUSTOMER TYPE]='I','MPR_13'

if([CUSTOMER TYPE]='C' or [CUSTOMER TYPE]='N' or [CUSTOMER TYPE]='S','Company,'Others')))))) as CATEGORIES,

Other than 'Motorcycle', was tag accordingly. I've use WildMatch & LIKE but still none of the account was tagged with it.

But if I run only 'Motorcyle' condition without others, system can tagged it accordingly.

Anybody have better idea to solve this query?

[tresesco]

Without a data sample it would be very hard. Please post sample app with a small data.

[#3]

I have attached the before tag & after tag in the excel file attached.

[tresesco]

PFA

[#5]

You can use it like this :

if(WildMatch([MAKE & MODEL],'*MOTORC*'),'Motorcycle',

if([REASON CODE]='SKIP','Exclusion List',

if([PRODUCT TYPE]='902' or [PRODUCT TYPE]='903','Floor Stocking',

if([PRODUCT TYPE]='900' or [PRODUCT TYPE]='901','Block Discounting',

if([DISBURSEMENT YEAR]=2013 AND [CUSTOMER TYPE]='I','MPR_13',

if([CUSTOMER TYPE]='C' or [CUSTOMER TYPE]='N' or [CUSTOMER TYPE]='S','Company','Others')
))))) as  CATEGORIES

[#6]

Have test it & its successfully tagged.

If the field provided previously were in different table, it was understood that I have join it, can the same query be used? Caused that was the real headache actually.

[#7]

Thanks for the assistance.