JOIN TOOL: same report, I have some transactions with the same information

[avo]

Hi everyone, 

I need some helps on my workflow. Please let me know if i use the correct tool .

I need to match Report A ( 52 transactions) with report B ( 50 transactions). I used JOIN TOOL ( fonction Vloop up)  to match them but I came out an output with 62 transactions !!!! ( Please see report C) !!!!

Then I noticed because in each input report ( A and B), I have a couple of transaction with the same transaction number !!!! 

How can i tell my workflow to match only one transaction from A to one transaction for B.

We should get  a final report with 52 lines only : 50 lines match between A& B and only 2 lines don't match. 

thank you so much for your hepls and advices 

Anh

[Luke_C · Accepted solution]

@avo 

You can use a summary tool before the join to 'Group By' the account codes and sum the units together so you just get one record per account code. 

[avo]

@Luke_C 

thank you so much,  yess, it works !!!!

again, thank you for your helps🙂

Anh