Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
---------------------------------------------------------------------------
//Tab1
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;
---------------------------------------------------------------------------
//Tab2
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
RESIDENT Species
GROUP BY CustomerID, SID;
---------------------------------------------------------------------------
Thanks a lot.
Species table does not exists, the LOADed table is joined to STests, right?
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.
//Tab2
//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
RESIDENT STests
GROUP BY CustomerID, SID;
Can I mark my own entry as an answer?
You sure can
I don't see that option to mark my above entry as an answer. Just wanted to complete this task.