Dear All,
i am using below code ......But did not getting expected output..I want Sarv Suraksha AS product_class2 for product_code 2950 marked in red colour below .......But i am getting reatil health as product_class2 for 2950 product.....Kindly suggest me how i can go with this..
if(wildmatch([Channel Partner-Channel Partner Name],'*HDFC BANK CC HEALTH*') and wildmatch([Product Details-Product Code],'HSP'),'Retail Health',
if(wildmatch([Product Details-Product Code],'HSP') and len([Channel Partner-Channel Partner Name])=0 or not(wildmatch([Channel Partner-Channel Partner Name],'*HDFC BANK CC HEALTH*')),'Retail Health',
if(wildmatch([Product Details-Product Code],2825) and wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',
'*BB000011HDFC BANK LTD (CLASSIC ON PHONE)*','*BB000010HDFC BANK LTD (PHONE BANKING)*'),'Retail Health',
if(wildmatch([Product Details-Product Code],2825) and len([Channel Partner-Channel Partner Name])=0 or not(wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',
'*BB000011HDFC BANK LTD (CLASSIC ON PHONE)*','*BB000010HDFC BANK LTD (PHONE BANKING)*')),'Retail Health',
if(wildmatch([Product Details-Product Code],2950) and wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',
'*BB000011HDFC BANK LTD (CLASSIC ON PHONE)*','*BB000010HDFC BANK LTD (PHONE BANKING)*'),'Sarv Suraksha',
if(wildmatch([Product Details-Product Code],2950) and not(wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',
'*BB000011HDFC BANK LTD (CLASSIC ON PHONE)*','*BB000010HDFC BANK LTD (PHONE BANKING)*')) or len([Channel Partner-Channel Partner Name])=0,'Sarv Suraksha',
if(wildmatch([Product Details-Product Code],'HSTOP') AND wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',
'*HDFC BANK CC HEALTH*'),'Retail Health',
if(wildmatch([Product Details-Product Code],'HSTOP') and not(wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',
'*HDFC BANK CC HEALTH*')) or len([Channel Partner-Channel Partner Name])=0,'Retail Health',
if(wildmatch([Product Details-Product Code],2849) AND wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',
'*HDFC BANK CC HEALTH*'),'Retail Health',
if(wildmatch([Product Details-Product Code],2849) and not(wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',
'*HDFC BANK CC HEALTH*')) or len([Channel Partner-Channel Partner Name])=0,'Retail Health',
if(wildmatch([Product Details-Product Code],2850) AND wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',
'*HDFC BANK CC HEALTH*'),'Retail Health',
if(wildmatch([Product Details-Product Code],2850) and not(wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',
'*HDFC BANK CC HEALTH*')) or len([Channel Partner-Channel Partner Name])=0,'Retail Health')))))))))))) AS Product_Class2
Sarfaraz
