How to combine three fields values into one field ?

[bhaveshp90]

Hello, 

I've 3 fields for managers as shown below; 

How can I combine Controls_Manager, Software_Manager, Mechanical_Manager into a new field in the load script?

So my new field "Manager" is 

Manager

Tautges Steve

Alfredson Tom

Gill Andrew

UNKNOWN

Jones Michael

Tautges Steven

N/A

Cost_temp:
LOAD 
[Project Number]&'-'&Region AS Link_Key,
[Project Number], 
Region, 
[Cost Area],
Var,
Quoted					
FROM [C:\Bhavesh\Qvd Files\VIEW_WSR_SAP_ORA_WBS_COST.qvd](qvd);

right join (Cost_temp)
LOAD 
PROJECT_NUMBER&'-'&REGION AS Link_Key,
D_PROJECT_KEY, 														
PROJECT_NUMBER, 												
MECHANICAL_MANAGER,															
SOFTWARE_MANAGER, 														
CONTROLS_MANAGER,														
REGION 																			
FROM [C:\Bhavesh\Qvd Files\DIM_PROJECT.qvd] (qvd);

Cost:
NoConcatenate
Load Distinct
*,
Var/Quoted as [Budget flag]
Resident Cost_temp;
Drop table Cost_temp;
Exit Script;

Attached is the file for reference

thanks

Bhavesh

[Claudiu_Anghelescu]

No Concatenate;
New_Table:
LOAD CONTROLS_MANAGER as new_field
resident Source_Table;

Concatenate

LOAD SOFTWARE_MANAGER
resident Source_Table;

Concatenate

LOAD MECHANICAL_MANAGER
resident Source_Table;