topic Qlikview case sensitive towards column names/table names in QlikView

Qlikview case sensitive towards column names/table names

rajtechnocraft — Fri, 22 Jul 2011 13:12:39 GMT

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 — Fri, 22 Jul 2011 13:26:18 GMT

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 — Fri, 22 Jul 2011 13:28:56 GMT

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

This will become laborious process..

Not Feasible

danielrozental — Fri, 22 Jul 2011 13:29:07 GMT

No, you can't avoid that.

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

kji — Fri, 22 Jul 2011 13:54:20 GMT

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.