Reconciliation of two Data sets

Hello All,

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

Example8.xlsx

Help

Accepted answers

atcodedog05

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 🙂

recon.yxmd

All comments

atcodedog05

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 🙂

recon.yxmd

Learner09

@atcodedog05 Thank you for the flow it worked!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703