Reconciliation- data in excel tabs

vishtrack

Hi All,

I have a problem which I'm trying to solve and need help. Attached excel for reference.

- I receive a reconciliation file on excel daily, with data in multiple tabs

- 'Main' tab contains data which acts as a reference for other 'Mirror' tabs

- I need to do a reconciliation of data set in each tab keeping Main as base

- I need to know which all additional line items are present in any of the mirror tabs that are Not on Main. I also need to know which Mirror tab does it pertain to

- I also need to know if there are any additional line items in any of the Mirror tabs that are not available in Main

Thank you in advance!

Alteryx test file.xlsx

WirkKarl

Hey! I’ve tackled similar reconciliation tasks before. One approach is to use the Join tool for each Mirror tab against the Main tab—this will let you see unmatched rows. You can also add a field with the tab name before appending all results, so you know which Mirror tab each extra line comes from. From there, a Union tool and a little filtering should give you exactly the items not present in Main. Hope that helps!