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.
You'd do it in a very similar way loading form qvd as SQL LOAD ID, Date, Count(ID) FRom table1 group by ID,Date; Join LOAD ID,Date,RecordCount FROM table2
