Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-03-20 05:37 PM

Modifying a database to include uppercase characters

I am trying to figure out how to use Force Case upper on the load screen.  I need to change a list of names from standard case to all Upper Case.  Do you know how to apply this to Edit Scipts page?  Also do you know how to remove a period from the end of a name?  Thank you very much for your help. 

299 Views
0 Likes
1 Reply
Not applicable
‎2013-03-20 05:56 PM
Author

You can use the Upper () function to get the desired result in the Load statement.

eg, LOAD Upper(Field1)  would returnt he values in that field in all Upper case.

Can you be specific on the period thing. Is it from a field value loaded from database or something else.

Hope this was helpful.

203 Views