I am trying to load data and make it all upper case, but upper() does not work in the script. Is there any other way to load all the data as uppercase, or to make Qlikview not case sensitive?
You can use, Upper(FieldName) in script, its working.. Can you post a sample file ..Its help to achieve the requirement
I am trying to
'select Upper(Username) from customerproducts'
and I get an error box that reads 'OLEDB read failed'
Try like this,
Load Upper(UserName) as UserName;
select UserName from customerproducts;
Hope it helps
Upper will work for sure in script
Can you tell me why your going for Case insensitive operation?
In the database there are information with names, sometimes written in all caps and sometimes not, but it is still the same name. I want the same names, no matter what case, to be grouped together in a table box..
Then MayilVahanan Suggestion will help you.
Which vendor database your using?
Load *, Upper(UserName) as UserName;
select * ,UserName from customerproducts;
What result it gave? Did satisfy your requirement?
Thanks, it worked when I added a load statement.
Retrieving data ...