- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Filter Data at load time
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load ... From ... Where Match(receiver,'heidic','chrisg','matthewcat');
HIC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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';
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thankyou very much!!!! Appreciate you taking the time on a novice like me.
cheers