Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
star_limit
Creator II
Creator II

Table not found join issue

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.


6 Replies
swuehl
MVP
MVP

Species table does not exists, the LOADed table is joined to STests, right?

star_limit
Creator II
Creator II
Author

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.

star_limit
Creator II
Creator II
Author

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
;

star_limit
Creator II
Creator II
Author

Can I mark my own entry as an answer?

sunny_talwar

You sure can

star_limit
Creator II
Creator II
Author

I don't see that option to mark my above entry as an answer. Just wanted to complete this task.