topic Re: Incremental load using excel sheets in QlikView

Incremental load using excel sheets

anuradhaa — Fri, 07 Aug 2015 09:18:58 GMT

I need to upload data using excel sheet monthly. excel sheet contain monthly data.

How can i load data incrementally.

Thanks

Re: Incremental load using excel sheets

Gysbert_Wassenaar — Fri, 07 Aug 2015 09:39:35 GMT

I wouldn't bother. If your excel files contain so much information that you see performance problems when you load all the data then you have bigger problems to worry about anyway. You should then seriously consider storing that much data in a real database.

If this answer doesn't satisfy you then search for and read some discussions on this topic:

https://community.qlik.com/search.jspa?q=excel+incremental+load

Re: Incremental load using excel sheets

anuradhaa — Fri, 07 Aug 2015 09:52:20 GMT

Thank You for the reply. Here i have only 100 records in my excel sheet.

What i did was create qvd from current excel sheet. then in the next moth load that sheet and concat with my qvd. the create new qvd with 2 month data and so on.

The problem i have is if someone reload that script twice a month, data will be duplicate. So i want to prvent this.

Hope you can understand what i'm saying.

Thank You

Re: Incremental load using excel sheets

Gysbert_Wassenaar — Fri, 07 Aug 2015 10:05:27 GMT

The easy way out is not to load the qvd, but simply load all the excel files. Or if you do want to use the qvd then move the excel file to another folder after loading it. Or use one of the many other solutions you can find on this site using the search feature.