Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
LESSASSY_K
Contributor III
Contributor III

Table not found after partial reload

Hello everyone,

I have this below situation where when reloading works but on partial reload i get table not found error.

Please help me out resolve this.

Here is the following code:

if IsPartialReload() then


// SharePoint Mapping_Sku_ID
CALL SP_GetFile('$(vL.SPSubSite)','$(vL.SPMapping_App)','Mapping_SKU_ID.xlsx','$(vL.Environment)');
//CALL SP_GetFile([$(vL.SPSubSite)],[$(vL.SPMapping_App)],'Mapping_SKU_ID.xlsx',[$(vL.Environment)]);

SKU_ID:
NoConcatenate LOAD
*
FROM $(v_FromSP_GetFile);

TRACE "PARTIAL LOAD CALLED";

//FROM [$(vL.QVDPath_App)Mapping_SKU_ID.xlsx];
//ENDIF

// exit from the script explicitly
ELSE

if not IsPartialReload() then
//
TRACE "FULL RELOAD";
//

 

TABLE 1:

LOAD *

FROM TABLE_NAME1;

END IF;
EXIT SCRIPT;

I don't understantd what is wrong.

The call function work well but in this it doesn't get the file (excel file withing sharepoint folder)

 

Thank you

Labels (2)
1 Reply
LESSASSY_K
Contributor III
Contributor III
Author

And without the partial reload statement

this code works perfectly fine

 

SKU_ID:
NoConcatenate LOAD
*
FROM $(v_FromSP_GetFile);

TRACE "PARTIAL LOAD CALLED";

 

That why i think it might be an issue with the partial load statement.

Thanks in advance