I currently am trying to match some transaction data (credit card authorization times and ticket validation times) using time as the primary key (best option I have) to do this, I am using an index match set to -1. the first ticket validation time finds the appropriate match from the credit card authorizations. The problem comes when some of the credit card authorizations are used more than once (highly unlikely especially since the charges on all the false positive results are different).
Long story short, I'm looking for a way to remove results from the index-match pool. I'm assuming this will probably have to be a macro of some kind. the problem with this was I didn't want to start the list all over again after each valid find (since that would increase the number of loops required to run exponentially.).
I'd post data but it is credit card data and I'm not allowed to share it. Any help would be greatly appreciated!
Long story short, I'm looking for a way to remove results from the index-match pool. I'm assuming this will probably have to be a macro of some kind. the problem with this was I didn't want to start the list all over again after each valid find (since that would increase the number of loops required to run exponentially.).
I'd post data but it is credit card data and I'm not allowed to share it. Any help would be greatly appreciated!
