Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding to an existing file

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?

5 Replies
Gysbert_Wassenaar

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.

FirstTable:

Load * from myfirstexcelfile.xls

(biff, embedded labels, table is sheet1$);

SecondTable:

Load * from mysecondexcelfile.xls

(biff, embedded labels, table is sheet1$);



talk is cheap, supply exceeds demand
Not applicable
Author

Thank you!

Not applicable
Author

Thank you!

Not applicable
Author

Thank you!

Not applicable
Author

Thank you!