Discussion Board for collaboration on QlikView Scripting.
Im having trouble doing a resident load. The following error message appears when I reload:
Table not found:
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,
Anybody know what is going wrong?
Go to Solution.
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.