topic Create new column of data with pre-existing data in QlikView

Create new column of data with pre-existing data

alwayslearning — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Create new column of data with pre-existing data

sunny_talwar — Tue, 21 Feb 2017 10:52:18 GMT

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

Data Cleansing

Re: Create new column of data with pre-existing data

alwayslearning — Tue, 21 Feb 2017 11:03:09 GMT

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