How to Extract Mismatch rows between two fields of two Tables

[Anonymous]

Hi,

i have an issue.please help me.

Table1:

------------

CardNo      TxnAmount      Date

4432xx45    300              26/07/2016

4432xx45    250              26/07/2016

4432xx45    300              26/07/2016

4431xx51     10              26/07/2016

4431xx51     20              25/07/2016

4432xx45    300             28/07/2016

Table2:

-----------------

Acno         Amount        Date

1069          300           26/07/2016

1069          200           26/07/2016

1169          300           26/07/2016

1239           10           26/07/2016

1239           15           25/07/2016

1345          300           28/07/2016 

Output Table

----------------

Date         MismatchAmount       Cardno       Acno

26/07/2016      250                  4432xx45     1069

25/07/2016      15                        --             1239

25/07/2016      20                    4431xx51       ----

Please guide me to get the output table.

[swuehl]

What's your key to identify which rows to compare?

[Anonymous]

i have to Compare Amount and TxnAmount row wise.No common column except Date

[Anonymous]

Hi

We have to create Key By

Amount&Date as key

and for 2nd table

TxnAmount&Date as key

[swuehl]

Don't your data show multiple rows per Amount&Date? So this will not identify single rows, right?

edit:

Maybe you can use something like demonstrated by John Witherspoon here:

How to compare 2 tables and put non-matching results?

[Anonymous]

Yes i have multiple data with dates.Repeatation is there with Date and Data.

[Anonymous]

Hi,

This attached file is my Sample Data.

please guide me.