topic How to fetch the updated data from the database though there exists the historical data in the same table? in QlikView https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026610#M936343 <HTML><HEAD></HEAD><BODY><P>How to fetch the updated data from the database though there exists the historical data in the same table?</P></BODY></HTML> Thu, 25 Feb 2016 09:44:47 GMT nishanthi_8 2016-02-25T09:44:47Z How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026610#M936343 <HTML><HEAD></HEAD><BODY><P>How to fetch the updated data from the database though there exists the historical data in the same table?</P></BODY></HTML> Thu, 25 Feb 2016 09:44:47 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026610#M936343 nishanthi_8 2016-02-25T09:44:47Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026611#M936344 <HTML><HEAD></HEAD><BODY><P><A href="http://www.quickintelligence.co.uk/qlikview-incremental-load/" title="http://www.quickintelligence.co.uk/qlikview-incremental-load/">http://www.quickintelligence.co.uk/qlikview-incremental-load/</A></P><P></P><P><A href="https://community.qlik.com/thread/48633">Incremental reload and store into QVD file</A></P></BODY></HTML> Thu, 25 Feb 2016 09:49:41 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026611#M936344 Anonymous 2016-02-25T09:49:41Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026612#M936345 <HTML><HEAD></HEAD><BODY><P>I dont have date field in that so how to fetch? </P></BODY></HTML> Thu, 25 Feb 2016 09:52:00 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026612#M936345 nishanthi_8 2016-02-25T09:52:00Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026613#M936346 <HTML><HEAD></HEAD><BODY><P>ya but i dont have time stamp to do that? so how can i?</P></BODY></HTML> Thu, 25 Feb 2016 10:22:40 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026613#M936346 nishanthi_8 2016-02-25T10:22:40Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026614#M936347 <HTML><HEAD></HEAD><BODY><P>By using the incremental load or direct connect the database reload the data&nbsp; than get the total data</P></BODY></HTML> Thu, 25 Feb 2016 10:30:03 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026614#M936347 Anonymous 2016-02-25T10:30:03Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026615#M936348 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P><A href="https://community.qlik.com/docs/DOC-9531">Incremental Load in Qlikview - Sources</A></P></BODY></HTML> Thu, 25 Feb 2016 10:30:58 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026615#M936348 Chanty4u 2016-02-25T10:30:58Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026616#M936349 <HTML><HEAD></HEAD><BODY><P>hi vsudhakar..... can you be clear at what u r saying</P></BODY></HTML> Thu, 25 Feb 2016 10:34:11 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026616#M936349 nishanthi_8 2016-02-25T10:34:11Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026617#M936350 <HTML><HEAD></HEAD><BODY><P>thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 25 Feb 2016 10:36:05 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026617#M936350 nishanthi_8 2016-02-25T10:36:05Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026618#M936351 <HTML><HEAD></HEAD><BODY><P>i have a doubt that incremental load data can only be used for insert , update and delete but these can be done with the data only wen we are going to add....... but what about the data where already it is there with historical dat a. for example&nbsp; the primary key is 101 and city has been changed from city1 to city2 now i need the changed city name..... here i dnt have any date field. and this i am doing in excel sheet and not using any databases..... this is the scenario i am asking for. Pls can anyone help me ?</P></BODY></HTML> Thu, 25 Feb 2016 10:40:41 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026618#M936351 nishanthi_8 2016-02-25T10:40:41Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026619#M936352 <HTML><HEAD></HEAD><BODY><P>‌how can you determine what has been created, updated or deleted? Usually this would be a unique Id and a modified date. </P></BODY></HTML> Thu, 25 Feb 2016 10:53:20 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026619#M936352 Anonymous 2016-02-25T10:53:20Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026620#M936353 <HTML><HEAD></HEAD><BODY><P>no we have been asked to work on the data provided for employees..... there the data is not adequate regarding the time stamp just hiring date and leaving date but not about the increment in the grade level and relocated list</P></BODY></HTML> Thu, 25 Feb 2016 10:56:54 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026620#M936353 nishanthi_8 2016-02-25T10:56:54Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026621#M936354 <HTML><HEAD></HEAD><BODY><P>reload the once when directly connect the database then the data is get</P></BODY></HTML> Thu, 25 Feb 2016 11:22:39 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026621#M936354 Anonymous 2016-02-25T11:22:39Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026622#M936355 <HTML><HEAD></HEAD><BODY><P>please close the thread if u get solution?</P><P>my marking correct and helpful answers.</P></BODY></HTML> Thu, 25 Feb 2016 12:46:11 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026622#M936355 Chanty4u 2016-02-25T12:46:11Z Re: How to fetch the updated data from the database though there exists the historical data in the same table? https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026623#M936356 <HTML><HEAD></HEAD><BODY><P>See dont force others to close the thread ........ </P></BODY></HTML> Thu, 25 Feb 2016 12:48:29 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-the-updated-data-from-the-database-though-there/m-p/1026623#M936356 nishanthi_8 2016-02-25T12:48:29Z