2 sources: Common fields

[#1]

Hi,

I have two files from two different sources. One file is from our internal database and one is clients.

My goal with this application is to notice differences.

I have attached my application and some pictures.

Based on some fields i'd like them to only show if theres any difference.

settledate + price + issell on one side contra

eod_SD + eod_price + eod_Side on the other side. They should be exact the same if not then show the diff.

[#2]

My key i generated by fields from 3 tables

contnotes gives me settledate,

instruments gives me lsearchname,

marketplacedeals gives me issell, price

Does that affect your mappingload?

[rubenmarin]

It will be based on the checks you want to do, from what I undesrtand of your first post, to check 3 fields at a time means those 3 tables are related, and you want to check each related row, so to do this the tables should be joined first in one table, from this table you can create the key.