Qlikview load script

[danielnevitt]

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';

[MK_QSL]

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'));

[sunny_talwar]

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';

[sasiparupudi1]

It is better to restrict the data in the source SQL for performance reasons and I would go with Manish's solution

[sunny_talwar]

Agreed