Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Not sure I complete understand, but may be look here?
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