cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DeepakBaberwal Frequent Visitor
Frequent Visitor

How to create an new column in abbreviated form ?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
pbiozkan Regular Visitor
Regular Visitor

Re: How to create an new column in abbreviated form ?

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.

1 REPLY 1
pbiozkan Regular Visitor
Regular Visitor

Re: How to create an new column in abbreviated form ?

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.