Build a report that matches between 2 tables

Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I would like to build a report that matches between 2 tables based on a common key that should exist in both tables.

I would like to show the matching rows marked "MATCH" and the ones without match marked "MISMATCH"

For the matched rows I would like to show only one record (not both rows from both tables) however records without a match should be shown from both tables.

Attached is a qvw with example

the Requested result table is bellow:

Inv_ID	Inv_Date	Inv_Name	Inv_TransactionNum	Inv_UniqueNum	Inv_Amount	Key
2411	23-05-16	Isracard	123	12345	70	Isracard70123	Match
2412	23-05-16	Isracard	456	45678	160	Isracard160456	Match
2413	23-05-16	Isracard	6789	6789	40	Isracard406789	mismatch
28396	02-06-16	Isracard	6789	6789	477	Isracard4776789	mismatch

Thank you!!

topic Build a report that matches between 2 tables in QlikView

Build a report that matches between 2 tables