Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
jeanful
Partner - Contributor II
Partner - Contributor II

Partial Reload of Last N Months: not finding table

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!

Labels (1)
2 Replies
robert_mika
Master III
Master III

Maybe

Qlik is case sensitive

You have SALES and Sales

 

jeanful
Partner - Contributor II
Partner - Contributor II
Author

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!