Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What's your key to identify which rows to compare?
i have to Compare Amount and TxnAmount row wise.No common column except Date
Hi
We have to create Key By
Amount&Date as key
and for 2nd table
TxnAmount&Date as key
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:
Yes i have multiple data with dates.Repeatation is there with Date and Data.
Hi,
This attached file is my Sample Data.
please guide me.