I am trying to use the Partial Reload code below to remove and add data to a table already loaded to Qlik Sense.
if IsPartialReload() then
[Temp_Table]:
NoConcatenate add only LOAD *
Resident Original_Table
where [criteria for keeping records]
;
drop table Original_Table;
[Original_Table]:
NoConcatenate add only LOAD *
Resident Temp_Table;
drop table Temp_Table;
LIB CONNECT TO 'Qlik-Connection';
[Original_Table]:
concatenate add only LOAD
[List of Fields];
SQL SELECT
`List of Fields`,
from `GCP Table`
end if()
The part in bold works and the required data is kept but the subsequent concatenate add only load doesn't bring the new data in, what do I need to change to get this working?