Resident Load issue

[#1]

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

[bbi_mba_76 · Accepted solution]

Hi,

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

[#3]

That seems to have worked.

Thanks!