identify duplicates while looping through weekly extracts

Fri, 22 Nov 2013 21:38:27 GMT

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:

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.

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

All the help is greatly appreciated.

Tom

Re: identify duplicates while looping through weekly extracts

Nicole-Smith — Sat, 23 Nov 2013 16:02:42 GMT

See the load script in the attached.

Re: identify duplicates while looping through weekly extracts

Mon, 25 Nov 2013 13:44:34 GMT

Hi Tom, do You tried use DISTINCT clause on your expressions?

Regards.

Re: identify duplicates while looping through weekly extracts

Tue, 10 Dec 2013 07:27:32 GMT

Great Nicole, Thanks for the help.

Marco

topic Re: identify duplicates while looping through weekly extracts in QlikView

identify duplicates while looping through weekly extracts

Re: identify duplicates while looping through weekly extracts

Re: identify duplicates while looping through weekly extracts

Re: identify duplicates while looping through weekly extracts