Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

how to find the changes in the file while loading


Hi Friends,

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.

Thanks

Pavan

Tags (1)
3 Replies

Re: how to find the changes in the file while loading

No,

you need a field that show the change ...

Re: how to find the changes in the file while loading

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!


talk is cheap, supply exceeds demand
Not applicable

Re: how to find the changes in the file while loading

Hi Friend,

Yes I have a primary key. But no date column.

Thanks

Pavan

Community Browser