Case-sensitive column names

[jjohnstonti618]

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

JJ

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

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.

[kaushiknsolanki]

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