Discussion board where members can get started with QlikView.
I've 3 fields for managers as shown below;
How can I combine Controls_Manager, Software_Manager, Mechanical_Manager into one new field in the load script?
[Project Number]&'-'&Region AS Link_Key,
FROM [C:\Bhavesh\Qvd Files\VIEW_WSR_SAP_ORA_WBS_COST.qvd](qvd);
right join (Cost_temp)
PROJECT_NUMBER&'-'®ION AS Link_Key,
FROM [C:\Bhavesh\Qvd Files\DIM_PROJECT.qvd] (qvd);
Var/Quoted as [Budget flag]
Drop table Cost_temp;
Attached is the file for reference
Is this what you are looking for:
write the below code in your script window:
Controls_Manager &'|' &Software_Manager, &'|' &Mechanical_Manager as New_Field
Hope this helps.
Hi, I'm looking to combine all the values into one field, I don't want to concatenate them. Like as shown below
Can you give us a clearer example of what each qvd contains and the result you hope to achieve? It would be easier to help you. regards!!!
Hope I am understanding this in the correct way. You want a manager field which is the combination of three manager fields. I think you want this as a separate table. Here is a sample script:
Load * Inline [MECHANICAL_MANAGER,SOFTWARE_MANAGER,CONTROLS_MANAGER,AmountJohn,Smith,Kevin,1000];
Managers:Load distinctMECHANICAL_MANAGER as ManagerResident Data;ConcatenateLOAD distinctSOFTWARE_MANAGER as ManagerResident Data;ConcatenateLOAD distinctCONTROLS_MANAGER as ManagerResident Data;
Now your Manger field will have all the mangers. Hope this helps..
Perhaps like this? But, one question...does it need to be joined to the table Cost (by Project key or Id or other)? Just add that field to each of the load statements below;
Combined:NoConcatenateLoad distinctCONTROLS_MANAGER as New_ManagerResident Costwhere not isnull(CONTROLS_MANAGER);
Concatenate(Combined)Load distinctMECHANICAL_MANAGER as New_ManagerResident Costwhere not exists(New_Manager,MECHANICAL_MANAGER)and not isnull(MECHANICAL_MANAGER);
Concatenate(Combined)LoadSOFTWARE_MANAGER as New_ManagerResident Costwhere not exists(New_Manager,SOFTWARE_MANAGER)and not isnull(SOFTWARE_MANAGER);
_N/A_ 1Alfredson Tom 1Gill Andrew 1Jones Michael 1Tautges Steve 1Tautges Steven 1UNKNOWN 1