topic Re: How to Extract Mismatch rows between two fields of two Tables in App Development https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117954#M19252 <HTML><HEAD></HEAD><BODY><P>What's your key to identify which rows to compare?</P></BODY></HTML> Wed, 03 Aug 2016 08:07:21 GMT swuehl 2016-08-03T08:07:21Z How to Extract Mismatch rows between two fields of two Tables https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117953#M19251 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have an issue.please help me.</P><P>Table1:</P><P>------------</P><P>CardNo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TxnAmount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date</P><P>4432xx45&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26/07/2016</P><P>4432xx45&nbsp;&nbsp;&nbsp; 250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26/07/2016</P><P>4432xx45&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26/07/2016</P><P>4431xx51&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26/07/2016</P><P>4431xx51&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25/07/2016</P><P>4432xx45&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28/07/2016</P><P></P><P></P><P>Table2:</P><P>-----------------</P><P> Acno&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date</P><P>1069&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26/07/2016</P><P>1069&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26/07/2016</P><P>1169&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26/07/2016</P><P>1239&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26/07/2016</P><P>1239&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25/07/2016</P><P>1345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28/07/2016&nbsp; </P><P></P><P></P><P>Output Table</P><P>----------------</P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MismatchAmount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cardno&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Acno</P><P>26/07/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4432xx45&nbsp;&nbsp;&nbsp;&nbsp; 1069 </P><P>25/07/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1239</P><P>25/07/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4431xx51&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----</P><P></P><P>Please guide me to get the output table.</P></BODY></HTML> Wed, 03 Aug 2016 07:47:59 GMT https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117953#M19251 Anonymous 2016-08-03T07:47:59Z Re: How to Extract Mismatch rows between two fields of two Tables https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117954#M19252 <HTML><HEAD></HEAD><BODY><P>What's your key to identify which rows to compare?</P></BODY></HTML> Wed, 03 Aug 2016 08:07:21 GMT https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117954#M19252 swuehl 2016-08-03T08:07:21Z Re: How to Extract Mismatch rows between two fields of two Tables https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117955#M19253 <HTML><HEAD></HEAD><BODY><P>i have to Compare Amount and TxnAmount row wise.No common column except Date</P></BODY></HTML> Wed, 03 Aug 2016 08:18:35 GMT https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117955#M19253 Anonymous 2016-08-03T08:18:35Z Re: How to Extract Mismatch rows between two fields of two Tables https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117956#M19254 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>We have to create Key By</P><P>Amount&amp;Date as key</P><P>and for 2nd table</P><P>TxnAmount&amp;Date as key</P></BODY></HTML> Wed, 03 Aug 2016 11:20:56 GMT https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117956#M19254 Anonymous 2016-08-03T11:20:56Z Re: How to Extract Mismatch rows between two fields of  two Tables https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117957#M19255 <HTML><HEAD></HEAD><BODY><P>Don't your data show multiple rows per Amount&amp;Date? So this will not identify single rows, right?</P><P></P><P>edit:</P><P>Maybe you can use something like demonstrated by John Witherspoon here:</P><P><A href="https://community.qlik.com/thread/32944">How to compare 2 tables and put non-matching results?</A></P></BODY></HTML> Wed, 03 Aug 2016 12:20:00 GMT https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117957#M19255 swuehl 2016-08-03T12:20:00Z Re: How to Extract Mismatch rows between two fields of two Tables https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117958#M19256 <HTML><HEAD></HEAD><BODY><P>Yes i have multiple data with dates.Repeatation is there with Date and Data.</P></BODY></HTML> Wed, 03 Aug 2016 12:35:12 GMT https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117958#M19256 Anonymous 2016-08-03T12:35:12Z Re: How to Extract Mismatch rows between two fields of two Tables https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117959#M19257 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>This attached file is my Sample Data.</P><P>please guide me.</P></BODY></HTML> Tue, 09 Aug 2016 08:37:23 GMT https://community.qlik.com/t5/App-Development/How-to-Extract-Mismatch-rows-between-two-fields-of-two-Tables/m-p/1117959#M19257 Anonymous 2016-08-09T08:37:23Z