Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the below load script and I would like some help restricting the load.
Ideally I would like to add:
CO_CD = A OR B OR C etc
OR CMDTY_CD = A OR B OR C etc
OR TRADE_LOCATION_CD = A OR B OR C etc
Any help would be much appreciated.
Regards,
Daniel
LOAD *,
Date(TITLE_TRANSFER_DT) AS TITLE_TRANSFER_DATE;
SQL SELECT
"ACTUAL_QTY",
"CMDTY_CD",
"CO_CD",
"CONTRACT_DT",
"TITLE_TRANSFER_DT",
"TRADE_LOC_REF",
"TRADE_LOCATION_CD",
"TRADE_TYPE"
FROM DATA_WAREHOUSE.VW_ACL_TRADE_FACT
WHERE TRADE_TYPE in ('Physical')
AND trunc(CONTRACT_DT) >= '01 JUN 2015';
LOAD *,
Date(TITLE_TRANSFER_DT) AS TITLE_TRANSFER_DATE;
SQL SELECT
"ACTUAL_QTY",
"CMDTY_CD",
"CO_CD",
"CONTRACT_DT",
"TITLE_TRANSFER_DT",
"TRADE_LOC_REF",
"TRADE_LOCATION_CD",
"TRADE_TYPE"
FROM DATA_WAREHOUSE.VW_ACL_TRADE_FACT
WHERE TRADE_TYPE in ('Physical')
AND trunc(CONTRACT_DT) >= '01 JUN 2015'
and (CO_CD in ('A', 'B','C') or CMDTY_CD in ('A','B','C') or TRADE_LOCATION_CD in ('A','B','C'));
Restriction in QlikView can be done as follows:
LOAD *,
Date(TITLE_TRANSFER_DT) AS TITLE_TRANSFER_DATE
WHERE Match(CO_CD, 'A', 'B', 'C') or Match(CMDTY_CD, 'A', 'B', 'C') or Match(TRADE_LOCATION_CD, 'A', 'B', 'C');
SQL SELECT
"ACTUAL_QTY",
"CMDTY_CD",
"CO_CD",
"CONTRACT_DT",
"TITLE_TRANSFER_DT",
"TRADE_LOC_REF",
"TRADE_LOCATION_CD",
"TRADE_TYPE"
FROM DATA_WAREHOUSE.VW_ACL_TRADE_FACT
WHERE TRADE_TYPE in ('Physical')
AND trunc(CONTRACT_DT) >= '01 JUN 2015';
It is better to restrict the data in the source SQL for performance reasons and I would go with Manish's solution
Agreed