topic Table not found join issue in QlikView

Table not found join issue

Anonymous — Fri, 28 Aug 2015 22:44:57 GMT

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.

Re: Table not found join issue

swuehl — Sat, 29 Aug 2015 00:01:16 GMT

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

Re: Table not found join issue

Anonymous — Sat, 29 Aug 2015 00:46:20 GMT

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.

Re: Table not found join issue

Anonymous — Sat, 29 Aug 2015 01:23:46 GMT

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;

Re: Table not found join issue

Anonymous — Sat, 29 Aug 2015 14:17:19 GMT

Can I mark my own entry as an answer?

Re: Table not found join issue

sunny_talwar — Sat, 29 Aug 2015 15:50:59 GMT

You sure can

Re: Table not found join issue

Anonymous — Sun, 30 Aug 2015 16:18:51 GMT

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