Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have data likes employees and their respective managers. Each employee are from different Branches.
Now I have got a scenario where I have set manager department as their new department which should come as new field. How can I do in load script.
please help on this.
Hi,
Try using Mapping Load something like below
Map_ManagerBranch:
Mapping Load
Agent_no,
Branch
From EmpTable;
Load
Agent_No,
Manager_No,
Branch,
ApplyMap('Map_ManagerBranch',Manager_No,Null()) as NewBranch
From EmpTable;
Hi,
Please share the sample data so that we can help you better.
Here is sample Data:
Below is expecting
Hi,
Try using Mapping Load something like below
Map_ManagerBranch:
Mapping Load
Agent_no,
Branch
From EmpTable;
Load
Agent_No,
Manager_No,
Branch,
ApplyMap('Map_ManagerBranch',Manager_No,Null()) as NewBranch
From EmpTable;
perfect. Thanks.. It is working as expected. I will try with real data.