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 the above

[viveksingh]

Any help on this

[shiveshsingh]

Hi

Can you share sample data and expected output?

Thanks

Shivesh Singh

[viveksingh]

Hi Thanks for the reply. 

Here is the data. I cannot upload data but can provide image.

Data:

Sample Data

Below is expecting

Expecting out put