0 Replies Latest reply: Sep 13, 2016 11:00 AM by Marco Vicariucci RSS

    Update table

    Marco Vicariucci

      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,

                            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);

       

       

       

      Somebody can hel me?