Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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. 

1 Reply
Not applicable

Re: Modifying a database to include uppercase characters

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.