Checking differences between 2 tables

[JayQueue]

Hello,

I'm comparing 2 tables for differences and my method is now:

ThashInput -> tMap <- - -> Lookup table and inner join on Field1. Catching rejects

OnSubjOk

Thashinput -> tMap

<- - -> Lookup table and inner join on Field2. Catching rejects

OnSubjOk

Thashinput -> tMap

<- - -> Lookup table and inner join on Field3. Catching rejects

...

(only 5 fields)

And I was wondering if there's a better/cleaner/re-usable way to do this? I looked on the Exchange but I couldn't find anything

Thanks!

Jonathan

[gjeremy1617088143]

Hi @Jonathan Quartier​ , i can suggest you to use  tAddCRCrow on each table to make Unique ID for Each combinaison of fields and compare them in a lookup, if you have difference then ,look in more detail field by field.

[JayQueue]

Thanks @guenneguez jeremy​ so not much different than I'm doing now.

It's a small dataset so I don't 9know if performance will increase with the tAddCRCrow but I'll keep that component in mind 🙂 Thanks for the tip!