topic Re: Load script not working with Upper() function in App Development

Load script not working with Upper() function

dranjbar — Mon, 20 Dec 2021 21:08:46 GMT

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?

Re: Load script not working with Upper() function

lironbaram — Mon, 04 Jan 2021 07:11:00 GMT

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

Re: Load script not working with Upper() function

jyothish8807 — Mon, 04 Jan 2021 08:23:15 GMT

May be try this:

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

FROM ....

Re: Load script not working with Upper() function

dranjbar — Mon, 04 Jan 2021 23:11:15 GMT

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

upper(CITY) as City1,

(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

Re: Load script not working with Upper() function

jyothish8807 — Tue, 05 Jan 2021 05:04:26 GMT

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