Add a field from a table to another table

[rmalkus]

How do I join fields from the Employees table into the Order table using the common, field, EmployeeID?

[vinieme12]

OrdersData:

Load *,EmployeeID  from datasource;

Left Join (OrdersData)

Load EmployeeID,EmployeeName from employeedatasource;

also refer below posts

https://community.qlik.com/t5/QlikView-App-Dev/Understanding-Join-Keep-and-Concatenate/td-p/328379

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592