Update table

Tue, 13 Sep 2016 15:00:50 GMT

Hi,

I have a table composed with several attributes. The table come from a sql select from ODBC source.

Some of the record in the database can update some of the attributes on his rows during database operations.
I know that the record of 5 days ago has completed their update changing.

I need a qliksense application that can load all the data from the database until now, save that on a qvd file but when I reload this application I need to update the rows from the qvd with the new data updated coming from the database.

For the qvd update I create something like this, but i'm not sure that it work well

let oggi = date(today(), 'DD/MM/YYYY');

let fiveDayAgo= date((today()-5), 'DD/MM/YYYY');

[Table]:

LOAD [IDOPERAZIONE],

[BUSINESSID],

[MSISDN],

[STATO],

[DATACREAZIONE],

[DATAAGGIORNAMENTO],

[NUMEROTENTATIVI],

[ESITO],

[MASSIMOTENTATIVI],

[TOKEN],

[ID_CAMPAGNA_M],

[ID_CAMPAGNA_S],

[NUM_SMS_PROP_RICEVUTI],

[CATEGORY],

[OPTYPE],

[IDCSP],

[TIPO_EVENTI]

FROM [$(loadWorkPath)operazione.qvd]

(qvd)

where [DATACREAZIONE]<=date('$(fiveDayAgo)');

concatenate

LOAD IDOPERAZIONE,

BUSINESSID,

MSISDN,

STATO,

DATACREAZIONE,

DATAAGGIORNAMENTO,

NUMEROTENTATIVI,

ESITO,

MASSIMOTENTATIVI,

TOKEN,

"ID_CAMPAGNA_M",

"ID_CAMPAGNA_S",

"NUM_SMS_PROP_RICEVUTI",

CATEGORY,

OPTYPE,

IDCSP,

"TIPO_EVENTI";

SQL SELECT IDOPERAZIONE,