column heading fields in script

Wed, 29 Jul 2015 23:04:30 GMT

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

Re: column heading fields in script

Gysbert_Wassenaar — Thu, 30 Jul 2015 05:47:58 GMT

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.

topic column heading fields in script in QlikView

column heading fields in script

Re: column heading fields in script