Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Maybe
Qlik is case sensitive
You have SALES and Sales
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!