column heading fields in script

[#1]

I am having this issue and I was wondering if anyone had any thoughts on how to solve it.

In the example, I would like to bring in the Name column  as  'Name'.  However, I have another file that has the same name but is CAPITALIZE. Therefore, my script below will not bring it in because file2.xls has the column name CAPITALIZE.  I would like to bring in both column heading (Name and NAME) to be Name. 

For example:

file 1.xls

Name,  Date, Age

File 2.xls

NAME, Date, Age

Load

Name,

Date,

Age

From file*.xls

[Gysbert_Wassenaar]

The obvious thing to do is to make sure you get source excel files with the same headers. It's not possible to use wildcard loading From file*.xls if the field names in the excel files differ. If you can only use Qlikview then you'll have to load the files individually and rename the fields manually.