How to write drool rules in .excel for second field dependent on first fileds selection and third field dependent on second fields selection

I am very new to drool rules. I have four fields, for which I want to write drools rules in excel. Scenario is, based on selection of product, values for customerType will be populated and based on selection of customerType, values for SubP开发者_运维问答roduct will be populated. And so on. enter image description here

For eg. For any product selected then customerType 260 and 262 will be returned. but, Now if someone selects customerType 260 then subProduct will be returned as '001','002','004'. Now if someone selects subProduct as 002 then LoanPurpose should be 05

enter image description here I have tried this. But since I am very new to this. I don't know how to write this properly. Please help me with this.