Filtering a table based on another table

[hjamison]

This seems simple but I'm about 3 weeks into learning Qlik Script and this is my first 3+ hour roadblock leaving me unable to find a solution my self.

I have two tables.

Table1 has 37 rows with DepartmentName and DepartmentNumber

Table2 has 350+ rows with DivisionNames.  However this table also happens to have all the DepartmentNames as values despite them not being Divisions.

I want to go through Table2 and 1) Search each row of DivisionNames and see if any DepartmentNames are present, if they are remove them from Table2. 2) AutoNumber the revised list of DivisionNames to get a new DivisionNumber.

I know this will involve making a temp table but I can't for the life of me figure out how to filter one field in a table by another field in a table. They all have exactly the same name, even case sensitive.

[Stoyan_Terziev]

Hi Hjamison,

You need to check the following functions:

Left Join, Inner Join, Left Keep, Right Keep, Exists, NOT Exists

If you need the script, please post example tables and your desired output.

Regards,

S.T.