Hello
I have a table with 40,000+ transactions and I wish to filter them using several criteria. The transactions have approx. 30 fields and I wish to use 4 of them to filter the transactions.
- My goal is to end up with a table of transactions that fit all 4 of my criteria.
The 4 fields that I wish to filter them by are:
- Product type (3 acceptable values)
- ISIN (100,000+ acceptable values)
- Counterparty code (30+ acceptable values)
- Trader (1000 acceptable values)
For each I field that I wish to filter by, I have a separate table which lists all the values that I want to pass the filter.
- desired result:
1 list of transactions that have values in the 4 filter fields that match values in the other tables.
Does anyone know the best way to go about this?
Many thanks
Aark
I have a table with 40,000+ transactions and I wish to filter them using several criteria. The transactions have approx. 30 fields and I wish to use 4 of them to filter the transactions.
- My goal is to end up with a table of transactions that fit all 4 of my criteria.
The 4 fields that I wish to filter them by are:
- Product type (3 acceptable values)
- ISIN (100,000+ acceptable values)
- Counterparty code (30+ acceptable values)
- Trader (1000 acceptable values)
For each I field that I wish to filter by, I have a separate table which lists all the values that I want to pass the filter.
- desired result:
1 list of transactions that have values in the 4 filter fields that match values in the other tables.
Does anyone know the best way to go about this?
Many thanks
Aark