Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load Specific Value Only

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?

1 Solution

Accepted Solutions
s_kunte23
Contributor III

Re: Load Specific Value Only

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

4 Replies
s_kunte23
Contributor III

Re: Load Specific Value Only

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

Re: Load Specific Value Only

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'

;

Re: Load Specific Value Only

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


Not applicable

Re: Load Specific Value Only

Thank you!!!

Community Browser