Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
theboss-123
Contributor III
Contributor III

Table not found error when loading data

Hello,

Please should be informed that when i tried to load data from tables usinginner join i got the below error

Table not found error

Table 'STOLOT' not found

inner join(STOLOT)
Load
ITMREF_0,
ITMDES1_0

and here is my script


SQL SELECT *
FROM sagex3lab.SEED.STOJOU;

Inner join(STOJOU)

Load
ITMREF_0,
LOT_0,
SLO_0;

SQL SELECT *
FROM sagex3lab.SEED.STOLOT;
inner join(STOLOT)
Load
ITMREF_0,
ITMDES1_0;

SQL SELECT *
FROM sagex3lab.SEED.ITMMASTER;
//-------- End Multiple Select Statements ------

 

8 Replies
Chanty4u
Champion III
Champion III

instead of innerjoin can you try with " 

NOCONCATENATE 

 

theboss-123
Contributor III
Contributor III
Author

Thanks for your reply can you show me where i can put on the script "NOCONCATENATE"

theboss-123
Contributor III
Contributor III
Author

it is working thank you 

theboss-123
Contributor III
Contributor III
Author

it is loading data but data not correct

slsaagar
Contributor II
Contributor II

Try this

Temp:
SQL SELECT *
FROM sagex3lab.SEED.STOJOU;

Inner join(Temp)

Load
ITMREF_0,
LOT_0,
SLO_0;

SQL SELECT *
FROM sagex3lab.SEED.STOLOT;
inner join(Temp)
Load
ITMREF_0,
ITMDES1_0;

SQL SELECT *
FROM sagex3lab.SEED.ITMMASTER;

theboss-123
Contributor III
Contributor III
Author

that is work but im unable to add date calendar

 

Load 

ACCDAT_0

Date(ACCDAT_0) As Date,
        Year(ACCDAT_0) As Year,
        Month(ACCDAT_0) As Month,
        Day(ACCDAT_0) As Day,
        Week(ACCDAT_0) As Week,
        'Q' & Ceil(Month(ACCDAT_0)/3) As Quarter,
        WeekYear(ACCDAT_0) & Num(Week(ACCDAT_0), '00') As YearWeek,
        Year(ACCDAT_0) & '-Q' & Ceil(Month(ACCDAT_0)/3) As YearQuarter,
        Date(MonthStart(ACCDAT_0), 'YYYY-MM') As YearMonth,
        -Year2Date(ACCDAT_0) As YTD_Flag,
        -Year2Date(ACCDAT_0, -1) As LYTD_Flag;

QFabian
Specialist II
Specialist II

Hi @theboss-123 , check this please , i just aded the resident clause:

 

Load 

ACCDAT_0,

Date(ACCDAT_0) As Date,
        Year(ACCDAT_0) As Year,
        Month(ACCDAT_0) As Month,
        Day(ACCDAT_0) As Day,
        Week(ACCDAT_0) As Week,
        'Q' & Ceil(Month(ACCDAT_0)/3) As Quarter,
        WeekYear(ACCDAT_0) & Num(Week(ACCDAT_0), '00') As YearWeek,
        Year(ACCDAT_0) & '-Q' & Ceil(Month(ACCDAT_0)/3) As YearQuarter,
        Date(MonthStart(ACCDAT_0), 'YYYY-MM') As YearMonth,
        -Year2Date(ACCDAT_0) As YTD_Flag,
        -Year2Date(ACCDAT_0, -1) As LYTD_Flag

Resident Temp;

QFabian
theboss-123
Contributor III
Contributor III
Author

it said the error below

Table not found error

Table 'Temp' not found

Load

IPTDAT_0,