Reconciliation of two Data sets

[Learner09]

Hello All,

I am trying to create a reconciliation/comparison of two data sets. Please assist. I have added all information in the attachment.

[atcodedog05 · Accepted solution]

Hi @Learner09 

Recon can be done with help of join tool.

Workflow:

1. Join data-1 & data-2 on ZoneID & Zone Name.

2. Unjoin (L & R anchor) are missing data in other.

3. Joined data is checked whether consume from left and right match

Note: In your scenario ZoneID & Zone Name does not create a unique pair hence there is many to many join. It is suggestable to use set of keys are create a unique combination.

Hope this helps 🙂

[Learner09]

@atcodedog05 Thank you for the flow it worked!

[Learner09]

Hello @atcodedog05  I used the summarize tool for Zone ID and Name, then added the Joint tool and filter, so that it gave unique ID and Name against each consume.

Thanks,

Mayank