Discussion Board for collaboration on QlikView Scripting.
I have a typical situation.
The user places text files in a folder and he updates couple of times a day.
There is no updated time column in the file he updates.
Is there any way to do incremental load only for those records he updated.
I used Filetime() function but it gives me the updated time but not updated records.
you need a field that show the change ...
Is there a primary key in the data? Or is it possible to create one? Otherwise it's impossible to tell which records are updated and which are new. And see the section Detecting changed records in this blog post: QlikView hash functions and collisions - The Qlik Fix! The Qlik Fix!
Yes I have a primary key. But no date column.