topic Re: table not found error in QlikView

table not found error

rdsuperlike — Mon, 26 Jan 2026 18:19:17 GMT

test:

LOAD

DIE_ITEM_NAME,

GDPW

;

SQL

select DIE.ITEM_NAME as DIE_ITEM_NAME, NVL(MAX(BOM.GDPW),1) as GDPW

from BOW.DIM_BOM_QC BOM, BOW.DIM_ITM_QC WAFER, BOW.DIM_ITM_QC DIE

where BOM.PARENT_ITM_PRODUCTN_ID = DIE.ITM_PRODUCTN_ID

and BOM.COMP_ITM_PRODUCTN_ID = WAFER.ITM_PRODUCTN_ID

and sysdate between BOM.EFF_FROM_DT and BOM.EFF_TO_DT

group by DIE.ITEM_NAME

order by DIE.ITEM_NAME;

store test into test.qvd(qvd);

The above code throws table not found error.

can anyone tell me what the issue is? bcz the sql returns the values.

Re: table not found error

alexantone — Tue, 23 Dec 2014 23:44:46 GMT

Hello rdsuperlike

One question

Does this query function in your database (Sql Server , Access...)?i think no

sysdate? in this query

sysdate could be used in expression ....but not in a query state.

maybe you can load table one by one

first ..BOW.DIM_BOM_QC BOM, ,

second...BOW.DIM_ITM_QC WAFER

third BOW.DIM_ITM_QC DIE

bye

Re: table not found error

anbu1984 — Wed, 24 Dec 2014 01:59:55 GMT

Do you have any other table before test with exactly two fields (DIE_ITEM_NAME,GDPW)? Then tables might have concatenated automatically

Table names are case sensitive. If you have different case for test table in Store statement, then you will get this error. But posted script has same case.

test:

LOAD

DIE_ITEM_NAME,

GDPW

;

SQL

select DIE.ITEM_NAME as DIE_ITEM_NAME, NVL(MAX(BOM.GDPW),1) as GDPW

from BOW.DIM_BOM_QC BOM, BOW.DIM_ITM_QC WAFER, BOW.DIM_ITM_QC DIE

where BOM.PARENT_ITM_PRODUCTN_ID = DIE.ITM_PRODUCTN_ID

and BOM.COMP_ITM_PRODUCTN_ID = WAFER.ITM_PRODUCTN_ID

and sysdate between BOM.EFF_FROM_DT and BOM.EFF_TO_DT

group by DIE.ITEM_NAME

order by DIE.ITEM_NAME;

store test into test.qvd(qvd);

Re: table not found error

jagan — Wed, 24 Dec 2014 02:29:58 GMT

Hi,

Comment the store statement and check whether the SQL statement executes correctly? If not then there is an issue withe the database table. Check whether you are using correct Connection string, hope this may be the issue.

Regards,

Jagan.