I have the following field:
From the country field above I want to create a Country2 field.
Country2 field values should be:
How can I create this field most efficiently please in the script?
ok for the second field Country2, but the question here is how you want it to be linked to the first field ?
Both of the fields will be in the same table.
I just want Australia, UK, US for Country2 if they are present in the Country field.
I think its possible with If statement,but you may need to hard code the country name.
If (Country = 'UK' or Country = 'US' or Country = 'Australia',Country) as Country2
Retrieving data ...