topic Re: LOAD statements in for loops in QlikView https://community.qlik.com/t5/QlikView/LOAD-statements-in-for-loops/m-p/781230#M668650 <HTML><HEAD></HEAD><BODY><P>Hi Joseph</P><P></P><P>Its hard to be certain about what you're trying to do without a bit more detail.</P><P>But it seems to me you want to empty a table and then re-use it. Would it be possible use</P><P></P><P>DROP TABLE xxxxxx</P><P>and then redefine it ?</P><P></P><P></P><P></P><P>Just a thought.</P><P>Regards</P></BODY></HTML> Thu, 06 Nov 2014 13:54:58 GMT richard_chilvers 2014-11-06T13:54:58Z LOAD statements in for loops https://community.qlik.com/t5/QlikView/LOAD-statements-in-for-loops/m-p/781229#M668647 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Just a quick one in case anyone knows. I am loading a table in a for loop in order to identify some values and use them one by one in another loop. For this to work I pretty much need the table to be flushed away after each iteration rather than just keep all rows that are added after each iteration. What's the best way to achieve this?</P><P></P><P>Thanks all in advance</P></BODY></HTML> Thu, 06 Nov 2014 13:47:31 GMT https://community.qlik.com/t5/QlikView/LOAD-statements-in-for-loops/m-p/781229#M668647 2014-11-06T13:47:31Z Re: LOAD statements in for loops https://community.qlik.com/t5/QlikView/LOAD-statements-in-for-loops/m-p/781230#M668650 <HTML><HEAD></HEAD><BODY><P>Hi Joseph</P><P></P><P>Its hard to be certain about what you're trying to do without a bit more detail.</P><P>But it seems to me you want to empty a table and then re-use it. Would it be possible use</P><P></P><P>DROP TABLE xxxxxx</P><P>and then redefine it ?</P><P></P><P></P><P></P><P>Just a thought.</P><P>Regards</P></BODY></HTML> Thu, 06 Nov 2014 13:54:58 GMT https://community.qlik.com/t5/QlikView/LOAD-statements-in-for-loops/m-p/781230#M668650 richard_chilvers 2014-11-06T13:54:58Z Re: LOAD statements in for loops https://community.qlik.com/t5/QlikView/LOAD-statements-in-for-loops/m-p/781231#M668652 <HTML><HEAD></HEAD><BODY><P>Hi Richard,</P><P></P><P>Apologies I did not express it correctly and the error appeared to be somewhere else! Thanks anyway</P></BODY></HTML> Thu, 06 Nov 2014 14:16:51 GMT https://community.qlik.com/t5/QlikView/LOAD-statements-in-for-loops/m-p/781231#M668652 2014-11-06T14:16:51Z