https://community.qlik.com/t5/App-Development/Comparing-Data-in-two-tables/m-p/1550634#M39686 <P>I am trying to determine the best way of comparing or joining two tables to get some requested data. I have two tables both with an ID field and Date field and in Table Two I also have a record count. What I need is a way of knowing the sum of record count and count of batch ID when the ID field and Date field in Table 1 and Table 2 match. I can do this easily with SQL but I need to do this in Qlik from the two QVD tables I have created from base text report data.&nbsp;</P> Thu, 28 Feb 2019 16:34:09 GMT rponichtera 2019-02-28T16:34:09Z https://community.qlik.com/t5/App-Development/Comparing-Data-in-two-tables/m-p/1550634#M39686 <P>I am trying to determine the best way of comparing or joining two tables to get some requested data. I have two tables both with an ID field and Date field and in Table Two I also have a record count. What I need is a way of knowing the sum of record count and count of batch ID when the ID field and Date field in Table 1 and Table 2 match. I can do this easily with SQL but I need to do this in Qlik from the two QVD tables I have created from base text report data.&nbsp;</P> Thu, 28 Feb 2019 16:34:09 GMT https://community.qlik.com/t5/App-Development/Comparing-Data-in-two-tables/m-p/1550634#M39686 rponichtera 2019-02-28T16:34:09Z https://community.qlik.com/t5/App-Development/Comparing-Data-in-two-tables/m-p/1550795#M39702 You'd do it in a very similar way loading form qvd as SQL<BR />LOAD ID, Date, Count(ID)<BR />FRom table1<BR />group by ID,Date;<BR />Join<BR />LOAD ID,Date,RecordCount<BR />FROM table2 Thu, 28 Feb 2019 21:48:49 GMT https://community.qlik.com/t5/App-Development/Comparing-Data-in-two-tables/m-p/1550795#M39702 dwforest 2019-02-28T21:48:49Z