Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_IDCALL 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 explicitlyELSE
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
And without the partial reload statement
this code works perfectly fine
That why i think it might be an issue with the partial load statement.
Thanks in advance