Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
viveksingh
Creator III
Creator III

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
Creator
Creator

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;

View solution in original post

4 Replies
santhiqlik
Creator
Creator

Hi,

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

viveksingh
Creator III
Creator III
Author

Here is sample Data:

Sample DataSample Data

 

 

 

 

 

 

 

 

 

 

Below is expecting

Expecting out putExpecting out put

santhiqlik
Creator
Creator

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;

View solution in original post

viveksingh
Creator III
Creator III
Author

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