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?
