topic Incremental load? in QlikView https://community.qlik.com/t5/QlikView/Incremental-load/m-p/81861#M13454 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I was wondering on the best way to set this up. Let me explain how the data is structured then what i want to do.</P><P></P><P>So in a database we have information structured like this</P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P>6/22/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>6/22/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P>6/22/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Joan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>6/23/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500</P><P>6/23/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2500</P><P></P><P>That is currently in out database.&nbsp; Tomorrow 6/24 info will be populated.</P><P></P><P>I have an extract loading in each file for 6/22, then 6/23 then i would need 6/24</P><P></P><P>Tomorrow when this data is captured a qvd called sales_6242018 will be created.</P><P></P><P>I do not want to reload, and do formulas on 6/22 or 6/23.</P><P></P><P></P><P>What would the proper way of loading just 6/24 info in?</P></BODY></HTML> Tue, 26 Jun 2018 20:47:39 GMT qlikofba 2018-06-26T20:47:39Z Incremental load? https://community.qlik.com/t5/QlikView/Incremental-load/m-p/81861#M13454 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I was wondering on the best way to set this up. Let me explain how the data is structured then what i want to do.</P><P></P><P>So in a database we have information structured like this</P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P>6/22/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>6/22/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P>6/22/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Joan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>6/23/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500</P><P>6/23/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2500</P><P></P><P>That is currently in out database.&nbsp; Tomorrow 6/24 info will be populated.</P><P></P><P>I have an extract loading in each file for 6/22, then 6/23 then i would need 6/24</P><P></P><P>Tomorrow when this data is captured a qvd called sales_6242018 will be created.</P><P></P><P>I do not want to reload, and do formulas on 6/22 or 6/23.</P><P></P><P></P><P>What would the proper way of loading just 6/24 info in?</P></BODY></HTML> Tue, 26 Jun 2018 20:47:39 GMT https://community.qlik.com/t5/QlikView/Incremental-load/m-p/81861#M13454 qlikofba 2018-06-26T20:47:39Z Re: Incremental load? https://community.qlik.com/t5/QlikView/Incremental-load/m-p/81862#M13455 <HTML><HEAD></HEAD><BODY><P>DO the following </P><P><A href="https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/" title="https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/">https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/</A></P></BODY></HTML> Wed, 27 Jun 2018 07:06:49 GMT https://community.qlik.com/t5/QlikView/Incremental-load/m-p/81862#M13455 Chanty4u 2018-06-27T07:06:49Z