Partial Reload of Last N Months: not finding table

jeanful — Tue, 16 Sep 2025 06:41:47 GMT

Hello experts, I have a table called Sales, which is fully loaded from Excel file.

I would perform a partial reload of the data of this table. The loading logic would be that only the last N months are updated. So, I'm simulating that the last N months come from inline table.

So the script should have:
- Full loading: all data is read from the excel
- Partial loading: only last N months are updated (from inline table).

This is the script I created. When launching partial reload, Qlik Sense Cloud says that the Sales table is not found. Why?

[Sales]: LOAD [ANNO], [MESE], [CLIENTE], [PRODOTTO], [QTA] FROM [lib://xxx/File1.xlsx] (ooxml, embedded labels, table is Foglio1); If IsPartialReload() Then [Sales]: LOAD * FROM [lib://xxx/TestDelta3M.qvd](qvd) where [MESE] <= Num(Month(Now()))-3; //Delta last N months [T_DELTA]: ADD LOAD * INLINE [ ANNO, MESE, CLIENTE, PRODOTTO, QTA 2025,7,C1,P1,1 2025,7,C1,P2,1 2025,7,C1,P3,1 2025,7,C2,P1,1 2025,7,C2,P2,1 2025,7,C2,P3,1 2025,7,C3,P1,1 2025,7,C3,P2,1 2025,7,C3,P3,1 2025,7,C4,P1,1 2025,7,C4,P2,1 2025,7,C4,P3,1 2025,7,C5,P1,1 2025,7,C5,P2,1 2025,7,C5,P3,1 2025,8,C1,P1,1 2025,8,C1,P2,1 2025,8,C1,P3,1 2025,8,C2,P1,1 2025,8,C2,P2,1 2025,8,C2,P3,1 2025,8,C3,P1,1 2025,8,C3,P2,1 2025,8,C3,P3,1 2025,8,C4,P1,1 2025,8,C4,P2,1 2025,8,C4,P3,1 2025,8,C5,P1,1 2025,8,C5,P2,1 2025,8,C5,P3,1 ]; Concatenate([SALES]) ADD LOAD * RESIDENT T_DELTA; EndIf; STORE Sales INTO [lib://xxx/TestDelta3M.qvd];

Here is the error:
Table 'SALES' not found The engine error code: Table not found error:11001 The error occurred here: Concatenate([SALES]) ADD LOAD * RESIDENT T_DELTA

Thank you!

Re: Partial Reload of Last N Months: not finding table

robert_mika — Tue, 16 Sep 2025 02:57:55 GMT

Maybe

Qlik is case sensitive

You have SALES and Sales

Re: Partial Reload of Last N Months: not finding table

jeanful — Tue, 16 Sep 2025 06:43:09 GMT

Thank, its' going through now! But there's another problem: it does not find the T_DELTA table when executing the following instruction:

Concatenate([SALES]) ADD LOAD * RESIDENT T_DELTA;

How can I concatenate delta rows into the full table from the qvd?

Thanks a lot!

topic Re: Partial Reload of Last N Months: not finding table in App Development

Partial Reload of Last N Months: not finding table

Re: Partial Reload of Last N Months: not finding table

Re: Partial Reload of Last N Months: not finding table