Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to filter data using two tables in a script

I have two tables one employees and the other departments. I have used these with others to get what I want and filtered the department table. There is however no way I can filter the employee table on it's own. If I link it to the department table in the script then I can use the description fiels as I already do for the department table.

question is what syntax do I need ot use to pull the data from both tables in the script, there is of course a field called department in each table to connect them.

2 Replies
Not applicable
Author

tblEmployees:

LOAD

EmpID,

EmpName,

DeptID;

SQL SELECT *

FROM tblEmployees;

Left join (tblEmployees)

LOAD

DeptID,

DeptName;

SQL SELECT *

FROM tblDept;

Not applicable
Author

Thanks for that, I had to reverse my tables around though so the department is used with the left join to remove the unwanted entries.