Hi Community Members,
I have two tables: contact & account details (banking products) one to many mapping linked via customer id (sample data attached). I need to find all the contacts that don't have a particular account type say IRA SAVINGS in the given example. When I am applying filters (screenshot attached) - it gives me cust_id 2 as well since it has checking account as well although I want it to give me only cust_id 1. How can I apply this filter? Thanks
Like
2 comments
21:28 Sep 16, 2024
Try changing
- "count > 0" to "count = 0"
- then change "AccountType != IRA SAVINGS" to "AccountType = IRA SAVINGS"
Ryan
Show all comments