Create new column of data with pre-existing data

[alwayslearning]

Hi,

I want to create a 3rd column of data which combine data fields from others.

E.g I have two columns in existing raw data and I want to create a 3rd column in my script which takes elements from Department1 & Department 2. So I want to take 'Microbiology' from Department1 and relabel it Science, 'Graphics Relabelled Art', 'Business taken from Department and changed to 'Business Studies'

Department        Department 1                             

Biology              Microbiology

Graphics            Graphics

Business            Financial Accounting

Biology               Medicine

Business            Marketing

General Studies

[sunny_talwar]

Not sure I complete understand, but may be look here?

Data Cleansing

[alwayslearning · Accepted solution]

Hi Sunny,

Thanks for looking at this.

I've think I've been able to solve my problem with the following;

if(Department='Biology','Science', if(Department1= 'Graphics','Art','')) as newDepartment