Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
Contributor 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.


Tags (1)
6 Replies
Highlighted
MVP
MVP

Re: Table not found join issue

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

Highlighted
Contributor II

Re: Table not found join issue

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.

Contributor II

Re: Table not found join issue

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
;

Highlighted
Contributor II

Re: Table not found join issue

Can I mark my own entry as an answer?

Highlighted

Re: Table not found join issue

You sure can

Highlighted
Contributor II

Re: Table not found join issue

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