Reconciling data files

[#1]

I have two data files that I'm trying to reconcile.  Once they are loaded, what is the best way to compare them?  There seem to be so many options that it boggles my mind.

[MK_QSL]

How you want to compare?  What is the objective?

[its_anandrjs]

1. Check its field name and the data in the fields for matching the records.

2. If same then concatenate the tables with flag fields.

3. For which scenario you want to compare the tables and check the data and make charts for comparision.

4. Basically reconcile is done for financial application then use the financial terms for reconcile method and create a model based on that.

[#4]

I want to compare all entries into 4 data fields.  Ideally they should be the same.  I need to identify the descrepancies. for example :  Smith, In Pay, $3.50, LIFE vs Smith, In Pay, $4.50, LIFE.

[MK_QSL]

Sharing your sample data file or apps would be great.