topic Load using a sub load in QlikView

Load using a sub load

nickedw0 — Sun, 02 Dec 2018 06:19:32 GMT

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.

Re: Load using a sub load

Anil_Babu_Samineni — Sun, 02 Dec 2018 07:16:21 GMT

Will INNER JOIN won't work?

Re: Load using a sub load

nickedw0 — Sun, 02 Dec 2018 14:36:25 GMT

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

Re: Load using a sub load

passionate — Sun, 02 Dec 2018 15:01:44 GMT

Provide some sample data to get quick solution.

Re: Load using a sub load

marcus_sommer — Mon, 03 Dec 2018 13:10:38 GMT

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