Table not found after partial reload

LESSASSY_K — Fri, 11 Jun 2021 12:36:36 GMT

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

Re: Table not found after partial reload

LESSASSY_K — Fri, 11 Jun 2021 15:52:22 GMT

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

topic Table not found after partial reload in QlikView

Table not found after partial reload

Re: Table not found after partial reload