Hi I have multiple countries which i want to upload in script in single format ,I have the script as follows but i am not able to load it
if(RegistrationStoreLocation='INDIA',India',if(RegistrationStoreLocation='JAPAN','Japan',if(RegistrationStoreLocation='CHINA','China'))) as Country,
Why don't you try using Captialize() function, if all you want is to make 1st letter upper case and all other lower case
Capitalize(RegistrationStoreLocation) as Country
i did not know of this function. Thank you
Ofcourse you do
yaar sunny i really don't know man.
Retrieving data ...