Skip to main content

Qlik

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: 
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. 

210 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.

114 Views