How to Extract Mismatch rows between two fields of... - Qlik Community

Anonymous · ‎2016-08-03

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 · ‎2016-08-03

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

Anonymous · ‎2016-08-03

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

Anonymous · ‎2016-08-03

Hi

We have to create Key By

Amount&Date as key

and for 2nd table

TxnAmount&Date as key

swuehl · ‎2016-08-03

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:

Anonymous · ‎2016-08-03

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

Anonymous · ‎2016-08-09

Hi,

This attached file is my Sample Data.

please guide me.

How to Extract Mismatch rows between two fields of two Tables