1 Reply Latest reply: Mar 6, 2017 9:04 AM by oskars caikovskis RSS

    Loop through a Table and add to another...

    Ian Cornish

      Hi all,

      I am working on Load script for Qlik Sense app, and need to be able to loop through the rows in a table, and add records to another table based on a series of logical analysis of the data.

       

      Table Example:

      SourceData

          

      RecNoABC
      1Open1/1/201728/2/2017
      2Closed30/1/201728/2/2017
      3Pending2/3/2017

       

      I want to loop through all the records in this table (there are currently ~10k records), and populate another table (which will link via RecNo to this) with the results of that analysis (Effectively an Audit Analysis)