IDEA Join - Only matching transaction once

2 posts / 0 new
Last post
jennifer81
Offline
Joined: 09/14/2018 - 13:34
IDEA Join - Only matching transaction once

Hello,
When completing a JOIN in IDEA, is there a way to prevent a transaction from being matched more than once? For example, I am matching on a member number and amount, but there may be multiple transactions with the same info... when I attempted to match it picked up the first transaction and matched it twice then ignored the second one.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Jennifer and welcome to the site.

When performing a join for the match only and all records in primary file what IDEA does is it will grab the first transaction in the primary file and then do a search in the secondary file for a match, once it finds a match this gets written to the new file, it then goes to the second transaction in the primary file and does the same thing, as soon as it finds one match IDEA is happy and goes to the next transaction.  If you want multiple matches you need to use the Visual Connector to do this.  

I am not sure what you mean by matching it twice, if you are using one of the joins it should only be doing one match.

I am not sure if I answered your question, let me know.

Thanks

Brian