Incremental Load for multiple excel file

[Anonymous]

Hi there,

Could anyone tell me how can we do multiple excel file load in increment manner. Suppose I have excel file suffix with the date and first file I loaded all the excel file with wildcard (*) into qvd. but next load it should only load the new excel file which is new in folder.

Any help would be appreciated!

Best,

Skumar

[sunny_talwar]

Did you ever find a solution or work around your situation?

[#3]

Did you get the solution for it?

[engishfaque]

Dear Shubham,

Create Sub Routine and Pass the table names as an argument. Folder path and File name must be variable.

Kind regards,

Ishfaque Ahmed

[qlikviewwizard]

Work around:

You can archive all old excel files to another folder by batch file and load the excel files data to QVD.

I think it will help you. Thank you.