topic Dynamic Data Update in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Data-Update/m-p/212877#M66743 <HTML><HEAD></HEAD><BODY><P>The usual syntax in QV would be:<BR /></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Table1: LOAD Col1, Col2, Col3 RESIDENT Table2</PRE></BLOCKQUOTE><BR />This assuming that Table2 has already been loaded (and is resident in memory), if not you need to replace the "RESIDENT Table2" with a "FROM" and a filename. <BR /><BR /> <P>HTH<BR />Peter</P></BODY></HTML> Sun, 17 Jan 2010 19:53:35 GMT prieper 2010-01-17T19:53:35Z Dynamic Data Update https://community.qlik.com/t5/QlikView/Dynamic-Data-Update/m-p/212876#M66742 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I tried to Insert multipe rows with a commande like "Insert Into [Table1] (Col1, Col2, Col3) Select Col1, Col2, Col3 From [Table2]" but it didn't work.</P><P>Does somebody know how to do that ?</P><P>Thk for your help.</P></BODY></HTML> Fri, 15 Jan 2010 00:18:20 GMT https://community.qlik.com/t5/QlikView/Dynamic-Data-Update/m-p/212876#M66742 2010-01-15T00:18:20Z Dynamic Data Update https://community.qlik.com/t5/QlikView/Dynamic-Data-Update/m-p/212877#M66743 <HTML><HEAD></HEAD><BODY><P>The usual syntax in QV would be:<BR /></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Table1: LOAD Col1, Col2, Col3 RESIDENT Table2</PRE></BLOCKQUOTE><BR />This assuming that Table2 has already been loaded (and is resident in memory), if not you need to replace the "RESIDENT Table2" with a "FROM" and a filename. <BR /><BR /> <P>HTH<BR />Peter</P></BODY></HTML> Sun, 17 Jan 2010 19:53:35 GMT https://community.qlik.com/t5/QlikView/Dynamic-Data-Update/m-p/212877#M66743 prieper 2010-01-17T19:53:35Z