How to create an new column in abbreviated form ?

[DeepakBaberwal]

suppose i am having a column "country" in my table in which "united state" is a value now i want a new column named "country code" an it should have "us".

how to do it?

[pbiozkan · Accepted solution]

Hi,

If you'll only change 1 or 2 value, try to duplicate column and replace values. Or, add another table with country names = united states and country codes= us and create a relationship.

Or, use extract if  "us" exists.