topic Re: Change values to uppercase while loading the excel table data in QlikView

Change values to uppercase while loading the excel table data

Wed, 19 Feb 2014 14:30:00 GMT

Hi all,

I'd like to load one column of an excel file transforming all the text in uppercase format.

What is the easiest way to do it in the load script?

Thank you.

Giuseppe

Re: Change values to uppercase while loading the excel table data

marcus_sommer — Wed, 19 Feb 2014 14:32:46 GMT

This could be done with UPPER(YOURFIELD) as Field.

- Marcus

Re: Change values to uppercase while loading the excel table data

Wed, 19 Feb 2014 14:41:19 GMT

Thank you Marcus.

I did it but when I have to refer to this field in the charts it seems I've always refer to the field as upper([Field Name]).

Is there any way to avoid repeating the upper function when using the field? CAn I rename it in the load script (i.e. new = upper(fieldname)). If yes, how can I do it?

Thank you again.

Giuseppe

Re: Change values to uppercase while loading the excel table data

alexandros17 — Wed, 19 Feb 2014 14:43:35 GMT

Ciao Giuseppe,

la risposta di Marcus è corretta, quando ti riferisci al campo, ripetendo l'esempio di Marcus devi utilizzare Field e non più UPPER(YOURFIELD)

Re: Change values to uppercase while loading the excel table data

marcus_sommer — Wed, 19 Feb 2014 14:45:32 GMT

This example was for loading within the script. In GUI you refers only with the fieldname: sum(Field).

- Marcus

Re: Change values to uppercase while loading the excel table data

Wed, 19 Feb 2014 14:52:39 GMT

Grazie

Re: Change values to uppercase while loading the excel table data

Wed, 19 Feb 2014 14:52:55 GMT

Thank you