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_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
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