Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Combine three fields into one field

Hello, 

I have a table with Cost_Area  field which has values as:


1.PNG

 

 

 

 

 

 

 

 

 

 

I am trying to combine multiple fields ('CONT HDWR', 'CONT RESALE', 'CONTROLS ENG') in load script as one field  (named "Controls Eng"). So, my resultant column "Controls Eng" would be a list having values like 'CONT HDWR', 'CONT RESALE', 'CONTROLS ENG' and not the other fields.  

How can I do this? 

attach is the file for reference

Labels (1)
1 Reply
Highlighted
Partner
Partner

not sure exactly what you mean. i see you are doing
[Cost Area]='CONT HDWR' , 'Cont Hdwr' why not change 'Controls Eng'
also if you use a applymap instead of the nested if it maybe faster