Change values to uppercase while loading the excel table data

[#1]

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

[marcus_sommer · Accepted solution]

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

- Marcus

[#3]

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

[alexandros17]

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)

[marcus_sommer]

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

- Marcus

[#6]

Grazie

[#7]

Thank you