if statement to upload multiple country

[#1]

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,

[sunny_talwar]

Why don't you try using Captialize() function, if all you want is to make 1st letter upper case and all other lower case

LOAD RegistrationStoreLocation,

          Capitalize(RegistrationStoreLocation) as Country

FROM ....

[Anonymous]

stalwar1

i did not know of this function. Thank you

[sunny_talwar]

Ofcourse you do

[Anonymous]

yaar sunny i really don't know man.