topic Selective Data Refresh in QlikView https://community.qlik.com/t5/QlikView/Selective-Data-Refresh/m-p/256892#M1208437 <HTML><HEAD></HEAD><BODY><P>My full data refresh takes many hours. I now need to add a small lookup table. Is there a way in which I can simply bring the lookup table without reloading all the tables in the document?</P><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Tue, 11 May 2010 19:28:41 GMT Anonymous 2010-05-11T19:28:41Z Selective Data Refresh https://community.qlik.com/t5/QlikView/Selective-Data-Refresh/m-p/256892#M1208437 <HTML><HEAD></HEAD><BODY><P>My full data refresh takes many hours. I now need to add a small lookup table. Is there a way in which I can simply bring the lookup table without reloading all the tables in the document?</P><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Tue, 11 May 2010 19:28:41 GMT https://community.qlik.com/t5/QlikView/Selective-Data-Refresh/m-p/256892#M1208437 Anonymous 2010-05-11T19:28:41Z Selective Data Refresh https://community.qlik.com/t5/QlikView/Selective-Data-Refresh/m-p/256893#M1208438 <HTML><HEAD></HEAD><BODY><P>Use the REPLACE command in your load and then do a Partial Reload.</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">REPLACE LOAD * FROM...</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 11 May 2010 19:59:26 GMT https://community.qlik.com/t5/QlikView/Selective-Data-Refresh/m-p/256893#M1208438 2010-05-11T19:59:26Z Selective Data Refresh https://community.qlik.com/t5/QlikView/Selective-Data-Refresh/m-p/256894#M1208439 <HTML><HEAD></HEAD><BODY><P>I currently do not have a load statement. All I have is ODBC connect. Then SQL Select statements. Do I have to comment out the SQL select of big tables &amp; add REPLACE LOAD? What is the syntax of REPLACE LOAD?</P><P></P><P>Thanks,</P><P>Dinesh</P></BODY></HTML> Tue, 11 May 2010 20:18:38 GMT https://community.qlik.com/t5/QlikView/Selective-Data-Refresh/m-p/256894#M1208439 Anonymous 2010-05-11T20:18:38Z Selective Data Refresh https://community.qlik.com/t5/QlikView/Selective-Data-Refresh/m-p/256895#M1208440 <HTML><HEAD></HEAD><BODY><P>The REPLACE can precede a LOAD or SELECT. Just use REPLACE SELECT...</P></BODY></HTML> Tue, 11 May 2010 20:35:31 GMT https://community.qlik.com/t5/QlikView/Selective-Data-Refresh/m-p/256895#M1208440 2010-05-11T20:35:31Z