Reconciliation - Unique Identification for each Match in the output

[Manohar053299]

I have 2 sets of data, name and amount. I have do the reconciliation by keep them as separate outputs.  We need a status column as Matched or Not Matched and an Unique Identification for each Match in the output.  How do we do this in macros?

Input 1:-

Name	Amount
A	10
A	10
B	10
C	30
D	40
E	50

Input 2:-

Name	Amount
A	20
C	30
D	40
D	60
E	50

Output 1:-

Name	Amount	Result	Matching Code
A	10	Match	1
A	10	Match	1
B	10	Not Matched
C	30	Match	2
D	40	Not Matched
E	50	Match	3

Output 2:-

Name	Amount	Result	Matching Code
A	20	Match	1
C	30	Match	2
D	40	Not Matched
D	60	Not Matched
E	50	Match	3

[AngelosPachis]

Hi @Manohar053299 ,

I've mocked up a workflow for you that I think does what you are looking for. However I don't see why "D" from Input 1 would not match "D" from Input 2 in your example. Can you clarify why this might be?

Output 1

Output 2

[Manohar053299]

D cannot be matched as total amount in input 1 is for D 40 vs input 2 is 100. However even if we do a line by line match we should still get D 60 in input 2 as not matched.

[AngelosPachis · Accepted solution]

Oh I see. Thanks for the extra info @Manohar053299 , I have amended the workflow to compare the total amounts in inputs 1 and 2 and I have converted it into a macro since you were interested in one. 

Hope that helps 🙂

Regards,

Angelos