Hello dear community, I would like to load my spreadsheets only incrementally. So only the records that have been added since the last loading. For this, I have built the following sample conflict in the data load script.
LIB CONNECT TO 'host.de (user)'; [Table 1]: LOAD [id] AS ID, [key_id] AS Key_id, [caseid] AS Case_id, [text] AS text; SQL SELECT id, key_id, CaseID, text FROM `Server`.`Table1` WHERE id> '$ (vMaxID_Table1)';
[MaxiMalWertTab]: Load max (Table1.id) AS MaxiMalWert resident Table1; Let vMaxID_Table1 = Peek ('MaxiMalWert'); drop table MaxiMalWertTab;
CONCATENATE LOAD [ID] [KEY_ID] [Case_d] [Text] FROM [lib: // resources (qlik1_administrator) /KPI/DEV/table1.qvd] (qvd) where not Exists(ID) ;
store [table1] into [lib: // resources (qlik1_administrator) /KPI/DEV/table1.qvd] (qvd);
I built this script following the tutorial on help.qlik.com, but it does not seem to work. Can any of you please help me? VG