If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
Try using Mapping Load something like below
ApplyMap('Map_ManagerBranch',Manager_No,Null()) as NewBranch
View solution in original post
Please share the sample data so that we can help you better.
Here is sample Data:
Below is expecting
Expecting out put
perfect. Thanks.. It is working as expected. I will try with real data.