Load Specific Value Only

[#1]

Brand new to Qlikview scripting, hope someone can help.  I want to only load lines with a specific value identified in them.  I've tried several different statements and I can't get them to work.  Here is the script:

LOAD:
     SAP_CUST_NO,
     DIST_CHANNEL as SHIPMENT_DIST_CHANNEL,
     ORD_STATUS,
     SAP_ITEM_NO as SHIPMENTS_SAP_ITEM_NO,
     ACT_SHIP_DATE as DAY_CODE,
     SHIP_QTY_SELL

FROM

(qvd);

I only want to load lines with the ORD_STATUS of S, how do I do this?

[Anonymous · Accepted solution]

Hi,

you can do this using a where clause:

LOAD:
     SAP_CUST_NO,
     DIST_CHANNEL as SHIPMENT_DIST_CHANNEL,
     ORD_STATUS,
     SAP_ITEM_NO as SHIPMENTS_SAP_ITEM_NO,
     ACT_SHIP_DATE as DAY_CODE,
     SHIP_QTY_SELL

FROM

(qvd) where match( ORD_STATUS, 'S');

Best regards

Stefan

[Anonymous]

LOAD:
    SAP_CUST_NO,
    DIST_CHANNEL as SHIPMENT_DIST_CHANNEL,
    ORD_STATUS,
    SAP_ITEM_NO as SHIPMENTS_SAP_ITEM_NO,
    ACT_SHIP_DATE as DAY_CODE,
    SHIP_QTY_SELL

FROM

(qvd)

WHERE     ORD_STATUS = 'S'

;

[its_anandrjs]

Try to load like

LOAD:
    SAP_CUST_NO,
    DIST_CHANNEL as SHIPMENT_DIST_CHANNEL,
    ORD_STATUS,
    SAP_ITEM_NO as SHIPMENTS_SAP_ITEM_NO,
    ACT_SHIP_DATE as DAY_CODE,
    SHIP_QTY_SELL
FROM
(qvd)

Where ORD_STATUS = 'S';

Here is assume ORD_STATUS has the values 'S' then use this  Where ORD_STATUS = 'S'; at the end of the load script and you can use Match(ORD_STATUS,'S') also

Regards

Anand

[#5]

Thank you!!!