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.
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.
