topic Where statement excludes multiple items from QVD in QlikView

Where statement excludes multiple items from QVD

cbaqir — Sat, 16 Nov 2024 18:03:25 GMT

I am having an issue with getting my script to correctly exclude two different things from the data load. Is there something wrong with my syntax? :

Fired:
LOAD EXP,
FIRING_RECORD,
EXP & '-' & RULE as %KEY_DOMAIN_RULE, //join to Rule table
RULE,
ALERT_DT_TM,
date(TRX_DATE, 'MM/DD/YYYY') as TRX_DATE,
RULE & '-' & date(MonthName(TRX_DATE),'MM-YY') as %KEY_RULE_TRX_DATE,
TRX_TIME,
ALERT,
FACILITY,
POSITION,
NURSE_UNIT,
ENCNTR_PRSNL_RELTN,
ALERT_RECIPIENT
FROM
[..\QVD\01_Extract_QVD\Fired.qvd]
(qvd)
where not WildMatch(POSITION, '*PFS*') and not WildMatch(ALERT,'*PT_CARE_DONOR_NETWORK*');

Re: Where statement excludes multiple items from QVD

Taoufiq_Zarra — Sat, 26 Sep 2020 09:07:48 GMT

@cbaqir and if ?

Fired: LOAD EXP, FIRING_RECORD, EXP & '-' & RULE as %KEY_DOMAIN_RULE, //join to Rule table RULE, ALERT_DT_TM, date(TRX_DATE, 'MM/DD/YYYY') as TRX_DATE, RULE & '-' & date(MonthName(TRX_DATE),'MM-YY') as %KEY_RULE_TRX_DATE, TRX_TIME, ALERT, FACILITY, POSITION, NURSE_UNIT, ENCNTR_PRSNL_RELTN, ALERT_RECIPIENT FROM [..\QVD\01_Extract_QVD\Fired.qvd] (qvd) where WildMatch(POSITION, '*PFS*')=0 and WildMatch(ALERT,'*PT_CARE_DONOR_NETWORK*')=0;

Re: Where statement excludes multiple items from QVD

ramchalla — Sat, 26 Sep 2020 13:25:07 GMT

@cbaqir , please include the below in where condition

Where not ( WildMatch(POSITION, '*PFS*')
and WildMatch(ALERT,'*PT_CARE_DONOR_NETWORK*'));

Re: Where statement excludes multiple items from QVD

cbaqir — Mon, 28 Sep 2020 14:18:28 GMT

I tired this but it didn't work.

Re: Where statement excludes multiple items from QVD

cbaqir — Mon, 28 Sep 2020 14:19:29 GMT

I tried this but it didn't work.

Re: Where statement excludes multiple items from QVD

marcus_sommer — Tue, 29 Sep 2020 13:34:26 GMT

Some example records would be helpful - which one should be included and which excluded. Maybe the concat of the conditions should be AND else OR or XOR or maybe any combination of them.

- Marcus