Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Highlighted
viveksingh
Contributor II

Manger dept as emp dept

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. 

1 Solution

Accepted Solutions
santhiqlik
Contributor

Re: Manger dept as emp dept

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;

4 Replies
santhiqlik
Contributor

Re: Manger dept as emp dept

Hi,

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

viveksingh
Contributor II

Re: Manger dept as emp dept

Here is sample Data:

Data.PNGSample Data

 

 

 

 

 

 

 

 

 

 

Below is expecting

Expecting.PNGExpecting out put

santhiqlik
Contributor

Re: Manger dept as emp dept

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
Contributor II

Re: Manger dept as emp dept

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

Community Browser