I have the below 2 tabs in QlikView and I get the correct results in my straight table. However, when I load the script, it breaks and displays table not found error. I have made the code part below in bold that is causing the problem. Could someone please tell me what I am doing wrong? What I am trying to do is just inner join STests table to Species table using two primary keys CustomerID and SID.
STests: LOAD CustomerID, PrintID, SID, Result as LResult, RDateTime; SQL SELECT CustomerID,PrintID,SID,Result,RDateTime FROM STests WHERE PrintID IN ('5001.01','6001.01','7001.01') AND CustomerID IN('C1234','C1554');
INNERJOIN(STests) LOAD CustomerID, MIN(RDateTime) AS RDateTime, PrintID RESIDENT STests GROUP BY CustomerID, PrintID;
I had replaced INNER JOIN(STests) with INNER JOIN(Species) but it gave me the same error and it breaks at that last join. Would you be able to correct,copy, and paste the code for me to see what I need to modify? Thanks.
I figured it out. Below is how I modified Tab2 and it fixed it. I looked at the table viewer on how it has joined the tables. It displayed on STests because of the inner join so I commented out "Species:" at the top and the resident load table becomes the STests.
//Species: INNER JOIN (STests) LOAD CustomerID, SID, CDatetime; SQL SELECT CustomerID,SID,CDatetime FROM Species WHERE CustomerID IN('C1234','C1554');
INNER JOIN(STests) LOAD CustomerID, SID, MIN(CDatetime) AS CDatetime RESIDENTSTests GROUP BY CustomerID, SID;