Qlikview case sensitive towards column names/table names

[rajtechnocraft]

Hi Community,

To my knowledge i think QV is case sensitive while reading column names/table names.

Can this be avoided.

I mean irrespective of case can QV read the data

Waiting for a quick response.

I require this beacuse lot my data extraction is manual feed .Data is coming from various excel sheets ,txt files,csv files etc.

So everytime if the columnanme case is not maintained my reload fails..

This has become a big headache for me as i have no control over Data providers.

Regards

Raj

[derekjones]

Hi Raj

You can ignore the headers of your source files when you load. Example:

Table1:

LOAD A as Column1,
     B as Column2,
     C as Column3

FROM
Exceldoc.xlsx
(ooxml, no labels, header is 1 lines, table is sheet1);

The important part above is "no labels, header is 1 lines"

Hope this helps

Derek

[rajtechnocraft]

In this case i need to change my script everywhere my feed is manual.

This will become laborious process..

Not Feasible

[danielrozental]

No, you can't avoid that.

What you should probably do is rename all fields to their upper case and then concatenate them.

[kji · Accepted solution]

At the start of your scrit put:

Force Case Upper;

It will make all fieldnames upper case.

Or have a look at the other options for the Force command if you prefer something else.