Filter Data at load time

[#1]

Hi all

I am loading a list of people from a field named receiver

How can I restrict the list of names in my script so that only certain records return?

I need to only return records where receiver name is heidic, chrisg or matthewcat

Can you help please?

thankyou in advance.

[hic]

Load ... From ... Where Match(receiver,'heidic','chrisg','matthewcat');

HIC

[maxgro]

and also like

and also =

TabFilter:

load *

where receiver like  'heidic' or receiver = 'chrisg'

;

LOAD * INLINE [

receiver

heidic

chrisg,

matthewcat

];

with your script

LOAD

     .......

FROM [..\PURCHASE_RECEIPT_NEW.qvd] (qvd)

where

     RECEIVER like 'heidic'  or RECEIVER like 'chrisg' or RECEIVER like 'matthewcat'; 

[#4]

Hi Henric

I am just not getting the result I need due to my lack of knowledge.  I have tried without success.  I have pasted my script below;  can you please type in the required script where it should go?  If I can see this, I may have a chance in future of better understanding.

ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='D/MM/YYYY';
SET TimestampFormat='D/MM/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Directory;

LOAD ORDER_NO,
     LINE_NO,
     RELEASE_NO,
     RECEIPT_NO,
     CONTRACT,
     PART_NO,
     DESCRIPTION,
     VENDOR_NO,
     RECEIPT_REFERENCE,
     NOTE_TEXT,
     QTY_ARRIVED,
     QTY_INSPECTED,
     QTY_TO_INSPECT,
     ARRIVAL_DATE,
     RECEIVER ,
     QTY_INVOICED,
     QC_CODE,
     NO_OF_INSPECTIONS,
     RECEIVE_CASE,
     RECEIVE_CASE_DB,
     QTY_CONSIGNMENT,
     AUTOMATIC_INVOICE,
     AUTOMATIC_INVOICE_DB,
     NOTE_ID,
     PRINTED_ARRIVAL_FLAG,
     PRINTED_ARRIVAL_FLAG_DB,
     PRINTED_RETURN_FLAG,
     PRINTED_RETURN_FLAG_DB,
     BUY_UNIT_MEAS,
     UNIT_MEAS,
     CONV_FACTOR,
     REQUISITION_NO,
     REQ_LINE,
     REQ_RELEASE,
     DEMAND_CODE,
     DEMAND_OPERATION_NO,
     DEMAND_ORDER_CODE,
     DEMAND_ORDER_NO,
     DEMAND_ORDER_TYPE,
     DEMAND_RELEASE,
     DEMAND_SEQUENCE_NO,
     MANUFACTURER_ID,
     PART_OWNERSHIP,
     PART_OWNERSHIP_DB,
     OWNING_CUSTOMER_NO,
     PROJECT_ID,
     ACTIVITY_SEQ,
     APPROVED_DATE,
     FINALLY_INVOICED_DATE,
     INV_QTY_ARRIVED,
     NOTIFIED_CONSUMED_QTY,
     AIRWAY_BILL_NO,
     OBJID,
     OBJVERSION,
     OBJSTATE,
     OBJEVENTS,
     STATE,
     OBJKEY

FROM

[..\PURCHASE_RECEIPT_NEW.qvd]
(qvd)

[hic · Accepted solution]

The "where match ..." Should be written right at the end of the load statement, right after "(qvd)". Note that everything i case sensitive, hence

... (Qvd) where Match(RECEIVER, 'heidic', ... )

hic

[#6]

Thankyou very much!!!!  Appreciate you taking the time on a novice like me.

cheers