Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I join fields from the Employees table into the Order table using the common, field, EmployeeID?
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