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

Add Data to My Excel Sheet

Hi to All,

I have my Excel Sheet & Reload & i designed datamodel & dashboard also.

But the problem is....Now I had same excel file along with added some records to that file like if  i had field product,added to that field...

and i want pull data from that file into Qlikview script,how can i do that..  Which Load I have to use...

Please help me..

Thanks in Advance.

3 Replies
Not applicable
Author

hi,

You can try this with incremental load..

Thanks

Not applicable
Author

Hi,

Im not fully sure I understand the question but I will give it a try.

If you have added new information to the source excel file (a new field) would you only need to add the name of the field in the original load statement. You can also use the little left marginal "hammer" to get the edit dialog for the load.

Good luck!

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Do you want a LOAD that automatically includes all new columns? Use LOAD * FROM...

More complex setups use variables to analyse the available columns and specify a column list throughout the script.