3 Replies Latest reply: Sep 6, 2017 10:53 AM by Przemyslaw Rybacki RSS

    Updating row data in table.

    Przemyslaw Rybacki

      Halo Qlik Community


      I want to make automatic update script, which runs every night. My system keeps data only from last 31 days, so it is rolling 31 days of data.



      I have archive table TA with ID column (values: 1-1000) from 1-1-2017

      and i have update table TU with ID column (values: 10-1009) from 2-1-2017


      What I need is data range 1-1009 and more every night.


      I'm quite new in Qlik sense, I heard something about left join or where not exist, but I'm not sure how to use it in that case.