topic For loop and incremental load in QlikView https://community.qlik.com/t5/QlikView/For-loop-and-incremental-load/m-p/1290159#M860532 <HTML><HEAD></HEAD><BODY><P>I have a facts table with a lot of rows! The columns are for example: <SPAN style="font-size: 10pt;">Date, Sales, Amount...... and so on.</SPAN></P><P><SPAN style="font-size: 10pt;">First I need to loop the table to get 12 weeks. And then do an incremental load to only load the new transactions into the table. How can I do this the best way?</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT sfloberg 2020-11-25T16:16:04Z For loop and incremental load https://community.qlik.com/t5/QlikView/For-loop-and-incremental-load/m-p/1290159#M860532 <HTML><HEAD></HEAD><BODY><P>I have a facts table with a lot of rows! The columns are for example: <SPAN style="font-size: 10pt;">Date, Sales, Amount...... and so on.</SPAN></P><P><SPAN style="font-size: 10pt;">First I need to loop the table to get 12 weeks. And then do an incremental load to only load the new transactions into the table. How can I do this the best way?</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/For-loop-and-incremental-load/m-p/1290159#M860532 sfloberg 2020-11-25T16:16:04Z Re: For loop and incremental load https://community.qlik.com/t5/QlikView/For-loop-and-incremental-load/m-p/1290160#M860533 <HTML><HEAD></HEAD><BODY><P>Take a look into the last two link-blocks within this document: <A href="https://community.qlik.com/docs/DOC-9038">Advanced topics for creating a qlik datamodel</A> which covers various approaches about incremental and optimized (qvd) loadings.</P><P></P><P>- Marcus</P></BODY></HTML> Sat, 21 Jan 2017 10:35:58 GMT https://community.qlik.com/t5/QlikView/For-loop-and-incremental-load/m-p/1290160#M860533 marcus_sommer 2017-01-21T10:35:58Z