Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Resident Load issue

Hey guys,

Im having trouble doing a resident load. The following error message appears when I reload:

Table not found:

TableDQ
etc etc

The resident load I tried is below:


[Filepath...\1198028.xlsx]

(
ooxml, embedded labels, table is [Tab1]);

Table_DQ:    

LOAD

[FITR],

if(FITR_No_Data='Fail', 'Fail',

if(FITR_ZeroValue='Fail', 'Fail',
if(FITR_DashValue='Fail', 'Fail',
if(FITR_DotValue='Fail', 'Fail',
if(FITR_MaxChar='Fail', 'Fail')))))  as FITR_DQ,

if(Report_Status_No_Data='Fail', 'Fail',
if(Report_Status_ZeroValue='Fail', 'Fail',
if(Report_Status_DashValue='Fail', 'Fail',
if(Report_Status_DotValue='Fail', 'Fail',
if(Report_Status_CN='Fail', 'Fail'))))) as Report_Status_DQ,

Resident Directory;

Anybody know what is going wrong?

Thanks

Mav

1 Solution

Accepted Solutions
bbi_mba_76
Valued Contributor

Re: Resident Load issue

Hi,

have you a table with Directory as name? It is a keyword and I suppose you have to change its name.

2 Replies
bbi_mba_76
Valued Contributor

Re: Resident Load issue

Hi,

have you a table with Directory as name? It is a keyword and I suppose you have to change its name.

Not applicable

Re: Resident Load issue

That seems to have worked.

Thanks!

Community Browser