7 Replies Latest reply: Nov 2, 2017 5:12 AM by Supriya R RSS

    custom Table to store records for each day in Qliksense

    Supriya R

      I have EmailMetricsTable where data will be updated every day by overriding datas. My requirement is to get records for each day and log records in other customTable, for each day.

       

      EmailMetricsTable:

       

      On day 25 oct EmailMetricsTable looks like

          

      idcampaign_idcomm_type_idsentdeliveredopendate_createddate_modified
      123401-07-2017
      223523301-07-201725-10-2017
      42372501-07-201725-10-2017
      523844501-07-201722-08-2017
      6224451702-07-201702-07-2017
      72245602-07-2017

       

       

      on day 26 oct EmailMetricsTable looks like (observe that date_modified is changed and sent,delivered, open are update)

        

      idcampaign_idcomm_type_idsentdeliveredopendate_createddate_modified
      123401-07-2017
      223577701-07-201726-10-2017
      423710501-07-201726-10-2017
      523816141501-07-201726-10-2017
      622447020702-07-201726-10-2017
      722456302-07-201726-10-2017
      822461226-10-2017

       

       

      so my custom log Table should be

         

      id campaign_id comm_type_id sent delivered open date_createddate_modified
      1234 01-07-2017
      223523301-07-201725-10-2017
      323577701-07-201726-10-2017
      423725 01-07-201725-10-2017
      5237105 01-07-201726-10-2017
      623844501-07-201722-08-2017
      723816141501-07-201726-10-2017
      8224451702-07-201702-07-2017
      922447020702-07-201726-10-2017
      1022456 02-07-2017
      11224563 02-07-201726-10-2017
      12224612 26-10-2017

       

       

      How could i create custom Log table like this. Any idea or help will be appreciated. Is it possible to do like this?

       

      Please help me on this.