Hi everyone. I have the following list: CustNo. LoanType 001 Auto 001 Housing 002 Housing 002 Auto 003 Auto 003 Housing 003 Auto 004 Housing 004 Auto 004 Housing 005 Auto 005 Auto 005 Housing 006 Housing 006 Auto 006 Auto Expected Output: CustNo. AutoThenHousing? HousingThenAuto? 001 1 0 002 0 1 003 1 1 004 1 1 005 1 0 006 0 1 As you can see, I want to check the order of loan availment (i.e. auto first then housing? or housing first then auto?) Take note also that there are cases wherein a customer availed multiple loans like 003 and 004. For these customers, both categories are true. Hope you can guide me on how to implement this in EG.Thanks.
... View more