Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
LOAD RegistrationStoreLocation,
Capitalize(RegistrationStoreLocation) as Country
FROM ....
i did not know of this function. Thank you
Ofcourse you do
yaar sunny i really don't know man.