Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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&'-'®ION 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