topic Exception Reporting in two tables in QlikView https://community.qlik.com/t5/QlikView/Exception-Reporting-in-two-tables/m-p/403886#M150265 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P></P><P>I am trying to produce an exception report (table). I have two tables of data (Orders &amp; Customer) that both have a field called Account Number. The Orders table may have multiple lines containing the account number and there may be duplicated ones in the Customer table (this probably won't matter but thought I'd mention it). </P><P></P><P>Besically what I am trying to do is produce a list (table) of unique account numbers that exist in the Orders table but NOT in the Customer Table. I want to be able to do this in a table as well rather than scripting. The idea is the Account NUmbers that don't exist in the customer table are reported on and added to the customer table manually. </P><P><BR />Thanks for any help. </P><P>Stu</P></BODY></HTML> Tue, 05 Feb 2013 10:15:45 GMT stuwannop 2013-02-05T10:15:45Z Exception Reporting in two tables https://community.qlik.com/t5/QlikView/Exception-Reporting-in-two-tables/m-p/403886#M150265 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P></P><P>I am trying to produce an exception report (table). I have two tables of data (Orders &amp; Customer) that both have a field called Account Number. The Orders table may have multiple lines containing the account number and there may be duplicated ones in the Customer table (this probably won't matter but thought I'd mention it). </P><P></P><P>Besically what I am trying to do is produce a list (table) of unique account numbers that exist in the Orders table but NOT in the Customer Table. I want to be able to do this in a table as well rather than scripting. The idea is the Account NUmbers that don't exist in the customer table are reported on and added to the customer table manually. </P><P><BR />Thanks for any help. </P><P>Stu</P></BODY></HTML> Tue, 05 Feb 2013 10:15:45 GMT https://community.qlik.com/t5/QlikView/Exception-Reporting-in-two-tables/m-p/403886#M150265 stuwannop 2013-02-05T10:15:45Z Re: Exception Reporting in two tables https://community.qlik.com/t5/QlikView/Exception-Reporting-in-two-tables/m-p/403887#M150266 <HTML><HEAD></HEAD><BODY><P>Look at the keyword "EXISTS", it does exactly what you want</P></BODY></HTML> Tue, 05 Feb 2013 10:23:04 GMT https://community.qlik.com/t5/QlikView/Exception-Reporting-in-two-tables/m-p/403887#M150266 alexandros17 2013-02-05T10:23:04Z