Load script not working with Upper() function

[dranjbar]

Hi,

I currently have a load script which starts off as:

Details:
FIRSTNAME as [Firstname],
upper(CITY) as City,

FROM ....

Currently it is loading "City" as however the city was entered (both lower and upper case) but I want it to all be in upper case which is why I have now added in upper(CITY) as City. Although when I press "Load Data" on my "Data load editor" it doesn't change neither the historical or new values for City in the sheet environment. It will bring in the new data to the sheet but city wont be in the uppercase format which is what I am looking for.

Am I doing something wrong somewhere?

[lironbaram]

Hi, 
your script seems ok, can you share sample data from to check the script,
also can you share the full load script 

[jyothish8807]

May be try this:

Details:
FIRSTNAME as [Firstname],
upper(text(CITY)) as City,

FROM ....

[dranjbar]

Tried that but didnt work, the thing is even if I change it to 

upper(CITY) as City1,

or

(CITY) as City1,

a new field doesn't get created called City1 so I feel like I'm doing something wrong with the process where its not refreshing the script. Am I suppose to be pressing the Load data button to do this?

Thanks

[jyothish8807]

Yes, unless you load the data the new fields will not be created.