Resident Load issue

Tue, 07 Jan 2014 16:40:37 GMT

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

Re: Resident Load issue

bbi_mba_76 — Tue, 07 Jan 2014 16:49:46 GMT

Hi,

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

Re: Resident Load issue

Tue, 07 Jan 2014 16:52:32 GMT

That seems to have worked.

Thanks!

topic Resident Load issue in QlikView

Resident Load issue

Re: Resident Load issue

Re: Resident Load issue