Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jjohnstonti618
Contributor III
Contributor III

Case-sensitive column names

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.

1 Reply
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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".