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
Solved! Go to Solution.
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.