Reconciling large datasets

Question

Scenario:

Let's say I have 2 excel files.  Each with the same amount of fields  (approx 80-100).  The field names will be identical.

I need to be able to reconcile each field against each other in the 2 datasets.  I can obviously build out the join tool simply enough which will throw up exceptions where data is in one but not the other.

I'd like to take it a step further and have an output that shows field 10 vs field 10 for example with a tag saying 'ok' or 'error'.  Again, not overly difficult on a one by one formula basis.  But is there one formula that could take care of this issue for multiple fields without having to input each formula for each calc (even though it's the same calc).

Thanks

Deano478 · Answer

@BenMurrells for this task you can use a combination of transpose and multi-field formula

Calvin6KV · Answer

@BenMurrells

Agree with the others, providing some sample data will make it easier to help.

Regardless, I tried to make some dummy datasets and built a workflow based on that.  Not sure if this helps.

Reconciling large datasets.yxmd

Raj · Answer

@BenMurrells 
please add some sample input and expected output.
will be in better position to help.