topic Re: Qlikview load script in QlikView

Qlikview load script

danielnevitt — Thu, 17 Sep 2015 13:54:55 GMT

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

Re: Qlikview load script

MK_QSL — Thu, 17 Sep 2015 13:56:36 GMT

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

Re: Qlikview load script

sunny_talwar — Thu, 17 Sep 2015 13:59:20 GMT

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

Re: Qlikview load script

sasiparupudi1 — Thu, 17 Sep 2015 14:20:11 GMT

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

Re: Qlikview load script

sunny_talwar — Thu, 17 Sep 2015 14:21:55 GMT

Agreed