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.

       

      Example:

      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.

       

       

      Greetings.