Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
have you a table with Directory as name? It is a keyword and I suppose you have to change its name.
Hi,
have you a table with Directory as name? It is a keyword and I suppose you have to change its name.
That seems to have worked.
Thanks!