topic Re: Table not found error when loading data in QlikView

Table not found error when loading data

theboss-123 — Wed, 06 Jan 2021 11:05:16 GMT

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 ------

Re: Table not found error when loading data

Chanty4u — Wed, 06 Jan 2021 11:09:15 GMT

instead of innerjoin can you try with "

NOCONCATENATE

Re: Table not found error when loading data

theboss-123 — Wed, 06 Jan 2021 11:16:57 GMT

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

Re: Table not found error when loading data

theboss-123 — Wed, 06 Jan 2021 11:18:48 GMT

it is working thank you

Re: Table not found error when loading data

theboss-123 — Wed, 06 Jan 2021 11:24:11 GMT

it is loading data but data not correct

Re: Table not found error when loading data

slsaagar — Wed, 06 Jan 2021 12:44:35 GMT

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;

Re: Table not found error when loading data

theboss-123 — Wed, 06 Jan 2021 14:22:04 GMT

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;

Re: Table not found error when loading data

QFabian — Wed, 06 Jan 2021 21:14:38 GMT

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

Load

ACCDAT_0,

Resident Temp;

Re: Table not found error when loading data

theboss-123 — Thu, 07 Jan 2021 16:28:44 GMT

it said the error below

Table not found error

Table 'Temp' not found

Load

IPTDAT_0,