Case-sensitive column names

jjohnstonti618 — Mon, 01 May 2017 02:54:39 GMT

Short question.

Is there a simple way to tell qlikview to IGNORE case sensitivity of column names (not data, dont care the about data) on user-submitted source excel files when loading a script?

Thanks

-------------------------------------------------------

FWIW, I've exhausted the community, google, etc and I am afraid the answer is no, but wanted to check for sure. applying "UPPER" or "force case" etc.. do not work for COLUMN NAMES...they just apply to the data itself. My users keep submitting fat-fingered excel column headers like [FIeld 1], [SAle 1], etc...where the second letter is capitalized while qlikview is ONLY looking for [Field 1], [Sale 1] and despite hours of testing upper, force case, temp tables, and scouring the web, i cant find a simple answer. id be shocked if qv12 didnt have some way to account for this--it has to be common issue, no?

This has been driving me nuts.

Re: Case-sensitive column names

kaushiknsolanki — Mon, 01 May 2017 06:05:12 GMT

Hi James,

You are right the answer is No. But I would like to tell you that you can use the load * statement to load whatever field name user has given.

That way it wont fail to load the script.

Regards,

Kaushik Solanki

topic Case-sensitive column names in QlikView

Case-sensitive column names

Re: Case-sensitive column names