3 Replies Latest reply: Dec 10, 2013 2:27 AM by marco rieben RSS

    identify duplicates while looping through weekly extracts

      Dear QlikView Community,

       

      I need help on identifying new records, while looping through a set of files, which do contain duplicate records.

      I have a folder that contains a number of files, which are a weekly extract. The structure of the table is the following:

      Weekly files.PNG.png

       

      Claim

      Date

      Amount

      Claim1

      01.01.2013

      10

      Claim2

      01.02.2013

      20

       

      My files, which the load script loops through:

       

      I am successfully able to loop through all the files; however, I would like to identify what the new amounts are that have been added for each week.

       

      The result that I am trying to achieve should ideally look like the column below, labeled "Weekly New Amount". This would give me the opportunity to identify easily what new amounts have been coming in on a weekly basis.

       

      Weekly Results.jpg

       

      I have enclose the .zip file, which contains the qvw and the source files.

      All the help is greatly appreciated.

       

      Tom