topic Re: Adding to an existing file in QlikView https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407771#M1155564 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Fri, 29 Mar 2013 18:53:36 GMT 2013-03-29T18:53:36Z Adding to an existing file https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407767#M1155560 <HTML><HEAD></HEAD><BODY><P>So once I've loaded an Excel spreadsheet but want to add more data from a different spreadsheet without loosing what "ve already added, How do I do that?</P></BODY></HTML> Fri, 29 Mar 2013 17:59:31 GMT https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407767#M1155560 2013-03-29T17:59:31Z Re: Adding to an existing file https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407768#M1155561 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Add a second load statement to add the data from the second excel file. When you reload data from both excel files will be loaded.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">FirstTable:</SPAN></P><P><SPAN style="font-size: 10pt;">Load * from myfirstexcelfile.xls </SPAN></P><P><SPAN style="font-size: 10pt;">(biff, embedded labels, table is sheet1$);</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">SecondTable:</SPAN></P><P><SPAN style="font-size: 10pt;">Load * from mysecondexcelfile.xls</SPAN></P><P><SPAN style="font-size: 10pt;">(biff, embedded labels, table is sheet1$);</SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P></BODY></HTML> Fri, 29 Mar 2013 18:49:25 GMT https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407768#M1155561 Gysbert_Wassenaar 2013-03-29T18:49:25Z Re: Adding to an existing file https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407769#M1155562 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Fri, 29 Mar 2013 18:53:25 GMT https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407769#M1155562 2013-03-29T18:53:25Z Re: Adding to an existing file https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407770#M1155563 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Fri, 29 Mar 2013 18:53:30 GMT https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407770#M1155563 2013-03-29T18:53:30Z Re: Adding to an existing file https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407771#M1155564 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Fri, 29 Mar 2013 18:53:36 GMT https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407771#M1155564 2013-03-29T18:53:36Z Re: Adding to an existing file https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407772#M1155565 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Fri, 29 Mar 2013 18:53:48 GMT https://community.qlik.com/t5/QlikView/Adding-to-an-existing-file/m-p/407772#M1155565 2013-03-29T18:53:48Z