Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
Consider you have two tables and loaded them into Qlikview and the two tables with be associated with DeptId, now if I want to load the Dname values into the first table by removing the second table completely from the data model then we use mapping load at this situations as below
Dept:
Mapping Load
DeptId,
Dname
from Dept;
Emp:
Load
EMPID,
Name,
DeptID,
Applymap('Dept',DeptID) as Dname
from emps;
The second table while loading will bring all the Dnames from the first table to the second table and after loading you won't find the first table in the data model.
There are some more advantages of using Applymap see the following link from Qlik Design group.
