topic Re: how to find the changes in the file while loading in QlikView https://community.qlik.com/t5/QlikView/how-to-find-the-changes-in-the-file-while-loading/m-p/660664#M668614 <HTML><HEAD></HEAD><BODY><P>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: <A href="http://www.qlikfix.com/2014/03/11/hash-functions-collisions/" title="http://www.qlikfix.com/2014/03/11/hash-functions-collisions/">QlikView hash functions and collisions - The Qlik Fix! The Qlik Fix!</A></P></BODY></HTML> Mon, 20 Oct 2014 07:48:07 GMT Gysbert_Wassenaar 2014-10-20T07:48:07Z how to find the changes in the file while loading https://community.qlik.com/t5/QlikView/how-to-find-the-changes-in-the-file-while-loading/m-p/660662#M668612 <HTML><HEAD></HEAD><BODY><P><BR />Hi Friends,</P><P></P><P>I have a typical situation.</P><P></P><P>The user places text files in a folder and he updates couple of times a day.</P><P></P><P>There is no updated time column in the file he updates.</P><P></P><P>Is there any way to do incremental load only for those records he updated.</P><P></P><P>I used Filetime() function but it gives me the updated time but not updated records.</P><P></P><P>Thanks</P><P>Pavan</P></BODY></HTML> Mon, 20 Oct 2014 07:39:58 GMT https://community.qlik.com/t5/QlikView/how-to-find-the-changes-in-the-file-while-loading/m-p/660662#M668612 2014-10-20T07:39:58Z Re: how to find the changes in the file while loading https://community.qlik.com/t5/QlikView/how-to-find-the-changes-in-the-file-while-loading/m-p/660663#M668613 <HTML><HEAD></HEAD><BODY><P>No,</P><P>you need a field that show the change ...</P></BODY></HTML> Mon, 20 Oct 2014 07:44:12 GMT https://community.qlik.com/t5/QlikView/how-to-find-the-changes-in-the-file-while-loading/m-p/660663#M668613 alexandros17 2014-10-20T07:44:12Z Re: how to find the changes in the file while loading https://community.qlik.com/t5/QlikView/how-to-find-the-changes-in-the-file-while-loading/m-p/660664#M668614 <HTML><HEAD></HEAD><BODY><P>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: <A href="http://www.qlikfix.com/2014/03/11/hash-functions-collisions/" title="http://www.qlikfix.com/2014/03/11/hash-functions-collisions/">QlikView hash functions and collisions - The Qlik Fix! The Qlik Fix!</A></P></BODY></HTML> Mon, 20 Oct 2014 07:48:07 GMT https://community.qlik.com/t5/QlikView/how-to-find-the-changes-in-the-file-while-loading/m-p/660664#M668614 Gysbert_Wassenaar 2014-10-20T07:48:07Z Re: how to find the changes in the file while loading https://community.qlik.com/t5/QlikView/how-to-find-the-changes-in-the-file-while-loading/m-p/660665#M668616 <HTML><HEAD></HEAD><BODY><P>Hi Friend,</P><P> Yes I have a primary key. But no date column.</P><P></P><P>Thanks</P><P>Pavan</P></BODY></HTML> Mon, 20 Oct 2014 07:53:13 GMT https://community.qlik.com/t5/QlikView/how-to-find-the-changes-in-the-file-while-loading/m-p/660665#M668616 2014-10-20T07:53:13Z