Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The objective is to purge matching values from the Mgr1SID column from all rows, not just the matching row.
Provide some sample data to get quick solution.
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