Load only matching records to previous loaded table

PaReD_SF85 — Fri, 15 Nov 2024 23:15:53 GMT

I have 3 tables of data. 2 tables contain Names and Alias of the owners. The 3rd table is basically the master table to enable the reporting of the name, alias, department, executive, etc.

Table1:

Product

Manager (this is a name)

Manager Alias

Table 2:

Project ID

Project Manager (this is a name)

Manager Alias

Table 3:

Employee Name

Alias

Department

Director

Executive

Location

Loading currently results in a loop when loading each table using the "as" clause to match Table 3's Name and Alias field names. (At times I have the alias only to compare to table 3 data and other times I the name only.)

Also, Table 3 really only needs the rows where the values common to both tables 1 and 2 exist. It's rather large and unnecessary to load all records for the organization.

Thoughts? Using WHERE to Load table 3 if Manager Name matches Employee Name results in "Manager Name field not found". I am not using Resident (or any other option) - just a simple Load * from the source file for each table.

(I haven't even thought of how to load the 2nd data table!)

Thank you for your help!

Re: Load only matching records to previous loaded table

edwin — Fri, 22 Jan 2021 22:34:34 GMT

attaching the script would help, you just need to make sure the field names are correct

where exists(Manager,[Employee Name]) should work assuming you already loaded the first table and Manager is the field for the name you want to compare.

topic Re: Load only matching records to previous loaded table in QlikView

Load only matching records to previous loaded table

Re: Load only matching records to previous loaded table