Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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