If Logic problem

[dhanu_today]

Hi everyone,

I need some help in the below script and attached the data and application as well.

In CASA+FD table the PRODUCT CA (second row) is not satisfing the CASA LOGIC.

WildMatch(PRODUCT_CODE,'200','201','202','203','204')

              or WILDMATCH(PROMO_CODE,'300','301','302','303','304')

              or WILDMATCH(TYPE,'Associate') AND WILDMATCH(PRODUCT,'CA','SA') ;

The above script is working fine in CASA field but giving some wrong value in CASA+FD.(Here we will get the list of CUST_IDS

under the PRODUCT FD with TYPE not equal to 'ASSOCIATE'.

(Purpose is to get the list of CUSTID'S which are having FD product with TYPE not equal to 'ASSOCIATE')

Thanks in advance,

Dhanu

[dhanu_today]

Thanks Aj.The logics you have mentioned for the individual counts of FD and CASA are correct.

But final level  CASA_Flag custids we have to check CASA CUSTID'S are having any FD relation with TYPE <> 'Associate' under the product FD.It means only FD relation with TYPE <> 'Associate' under the product FD custids are no need to consider.We have to consider when they have CASA relation also.

Thanks,

Dhanu

[nilesh_gangurde · Accepted solution]

PFA

-Nilesh

[dhanu_today]

Thanks Nilesh G...Its working fine.

Dhanu