Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
Thanks
Hi,
Try like this,
Load Upper(UserName) as UserName;
select UserName from customerproducts;
Hope it helps
Hi,
You can use, Upper(FieldName) in script, its working.. Can you post a sample file ..Its help to achieve the requirement
Upper will work for sure in script
Can you tell me why your going for Case insensitive operation?
I am trying to
'select Upper(Username) from customerproducts'
and I get an error box that reads 'OLEDB read failed'
Hi,
Try like this,
Load Upper(UserName) as UserName;
select UserName from customerproducts;
Hope it helps
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..
Thanks
Hi,
Then MayilVahanan Suggestion will help you.
Which vendor database your using?
Hi,
Try like this,
Load *, Upper(UserName) as UserName;
select * ,UserName from customerproducts;
What result it gave? Did satisfy your requirement?
Hope it helps
Thanks, it worked when I added a load statement.