Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load an Excel file via Load Data Editor to increment it in a report

Hi Guys,

Let me expose my need:

I receive everyday an Excel file in a network path. The path is always the same but the file name is a variable like: "Statistics_2016-10-11". I mean, the file name changes according to the current date.

This Excel file data has to be incremented into the report in order to keep the existing data in the report and add that newer data from Excel.

Tomorrow I'll receive a file called "Statistics_2016-10-12", so the data loaded today has to be kept and the data from "Statistics_2016-10-12" has to be incremented.

Could anyone provide me a code to Load it dynamically? 

In addition, is it possible to schedule a data load in order to load it everyday at 5:30 AM for example, or set a trigger to catch the file when it come to the mapped path?

Thanks in advance.

Tags (2)
Community Browser