See new data after reload

[knightwriter]

Hi all,

Is it possible to create a new table and a forumlised text box to list out the new rows of information that have been added / changed after a daily refresh?

Kind regards.

[Gysbert_Wassenaar]

Yes, if you mark the new records with for example the reload timestamp. If you add a field to the table with the time the records are loaded you can use that to create a table that shows only the new records by selecting the maximum value in that reload-time field.

[knightwriter]

Hi Gysbert,

Interesting answer but when I use ReloadTime(), will the table field not be the same as the refresh time once the reload happens? This making it difficult to separate the two differences. Prehaps an example if you could?

[Gysbert_Wassenaar]

I assume you are doing incremental loading. Otherwise how can you now which records are new? If you reload a qlikview document the first thing that happens is that all the data is removed. Qlikview does not remember anything from a previous load other than the last previous time the script was executed. Your data must contain a field that indicates the difference between old and new records. That's usually a datetime field that contains a modification date of the record.

[Anonymous · Accepted solution]

Are you doing a Full or an Incremental Load ?

If Incremental then stamp all Incremental rows added with the timestamp from Now().

[knightwriter]

I am completing full task reloads. Thats why I asked the initial question to understand if it were possible and how to do it. Appreciate the update.

[knightwriter]

Full Load.

Will try incremental & timestamp and see how I get on. Cheers.