Current script below. This works great for finding newly created incidents from the last load but now I want to update my QVD incidents where sys_updated_on has been updated.
I think I need to load the old data, query for new incidents where sys_updated_on > max(sys_updated_on), and then load old where not in new? This is what I don't know how to accomplish with ODBC SELECT vs LOAD.
FROM [incidents.qvd] (qvd);
LOAD max(sys_created_on) as MaxDate
LET vMaxDate = chr(39) & TimeStamp(PEEK('MaxDate', 0, 'MaxDate')) & chr(39);