Manger dept as emp dept

[viveksingh]

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. 

[santhiqlik]

Hi,

Please share the sample data so that we can help you better.

[viveksingh]

Here is sample Data:

Sample Data

Below is expecting

Expecting out put

[santhiqlik · Accepted solution]

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;

[viveksingh]

perfect. Thanks.. It is working as expected. I will try with real data.