topic Get unmatched records in QlikView https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458010#M796065 <HTML><HEAD></HEAD><BODY><P>Hi frnds,</P><P>I have two seperate table table1 and table 2. i want to load the unmatched records from both table in load script as see the attachment below. Kindly share your knowledge.</P><P><IMG alt="Snap.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/188720_Snap.png" style="height: 349px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT praveenkumar_s 2020-11-25T16:16:04Z Get unmatched records https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458010#M796065 <HTML><HEAD></HEAD><BODY><P>Hi frnds,</P><P>I have two seperate table table1 and table 2. i want to load the unmatched records from both table in load script as see the attachment below. Kindly share your knowledge.</P><P><IMG alt="Snap.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/188720_Snap.png" style="height: 349px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458010#M796065 praveenkumar_s 2020-11-25T16:16:04Z Re: Get unmatched records https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458011#M796066 <HTML><HEAD></HEAD><BODY><P>t2:</P><P>load id, id as filter, name from Table2.</P><P>output:</P><P style="font-size: 13.3333px;">Load id, name from Table1</P><P style="font-size: 13.3333px;">where not exists(filter,id);</P></BODY></HTML> Wed, 03 Jan 2018 12:23:18 GMT https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458011#M796066 Clever_Anjos 2018-01-03T12:23:18Z Re: Get unmatched records https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458012#M796067 <HTML><HEAD></HEAD><BODY><P>Looks for <A href="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/InterRecordFunctions/Exists.htm" title="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/InterRecordFunctions/Exists.htm">Exists - script function ‒ QlikView</A></P></BODY></HTML> Wed, 03 Jan 2018 12:23:57 GMT https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458012#M796067 Anil_Babu_Samineni 2018-01-03T12:23:57Z Re: Get unmatched records https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458013#M796068 <HTML><HEAD></HEAD><BODY><P>Please see attached example using Where Not Exists(ID,ID)</P></BODY></HTML> Wed, 03 Jan 2018 13:12:01 GMT https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458013#M796068 Anonymous 2018-01-03T13:12:01Z Re: Get unmatched records https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458014#M796069 <HTML><HEAD></HEAD><BODY><P>It is also working correctly.thanks for your help.</P></BODY></HTML> Wed, 03 Jan 2018 18:46:55 GMT https://community.qlik.com/t5/QlikView/Get-unmatched-records/m-p/1458014#M796069 praveenkumar_s 2018-01-03T18:46:55Z