Loading data with specified fields from all excel files in a folder

[#1]

Below is the scenerio i want to implement in my project.

There are 100 xls files in a folder, where some of  files having fields - a,b,c , d  some files having fields only - a , b .

I want to load data from all xls files in that folder into one table containing all the 4 fields - a,b,c, d and store it into a qvd.

Note : It is not possible for me to find the name of the files which have all the 4  fields,  as the files are being added everyday whereas only few files will ve all fields.

Can anyone help me a quick solution for this.

Thanks,

Sankar

[rwunderlich]

Download the QV Cookbook from

http://robwunderlich.com/downloads/

and take a look at the example "Load multiple sheets from Excel workbook". You may be able to adapt it your needs.

See also:

http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html

-Rob