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,
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 DATA_OPERAZIONE"
where DATACREAZIONE >= to_date('$(fiveDayAgo)','DD-MM-YYYY') and DATACREAZIONE< to_date('$(oggi)','DD-MM-YYYY');
store [Table] into [$(loadWorkPath)operazione.qvd](qvd);
