Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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*');
@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;
@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;
@cbaqir , please include the below in where condition
Where not ( WildMatch(POSITION, '*PFS*')
and WildMatch(ALERT,'*PT_CARE_DONOR_NETWORK*'));
I tired this but it didn't work.
I tried this but it didn't work.
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