Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
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,