Load using a sub load

[nickedw0]

I need to filter out values from one field which occur in another field. I thought something like the following , but cannot get Qlikview to work:

tMgr2:
Load distinct
 Mgr2SID as NewMgr2SID
 ,Mgr2Name as NewMgr2Name
  Resident tQC_Exceptions

  Where Mgr2SID Not exists
    (Load distinct Mgr1SID
     Resident tQC_Exceptions)
  ;

Any help would be appreciated.

[Anil_Babu_Samineni]

Will INNER JOIN won't work?

[nickedw0]

The objective is to purge matching values from the Mgr1SID column from all rows, not just the matching row.

[passionate]

Provide some sample data to get quick solution.

[marcus_sommer]

Within the where-clause is no further load possible but the following is quite common to filter loads based on another load:

Load distinct Mgr1SID as Mgr2SID Resident tQC_Exceptions;

tMgr2: Load distinct
     Mgr2SID as NewMgr2SID, Mgr2Name as NewMgr2Name
Resident tQC_Exceptions  Where Not exists(Mgr2SID);

Important by this approach is to use the right fields and to keep in mind that the match runs against a field and not fields within a certain table and therefore it might be necessary to adjust the load-order or to rename fields and similar things.

- Marcus