Exclude in Search in a Load Statement

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a load statement which is as follows

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='D/M/YYYY';

SET TimestampFormat='D/M/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';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-SG';

LOAD active,

purchase_ok,

rental,

sale_ok,

standard_price,

sale_delay,

ean13,

default_code,

produce_delay,

mes_type,

DESC,

procure_method,

type,

list_price,

supply_method,

[Supplier/Supplier],

[Supplier/Supplier Product Code],

[Supplier/Supplier Product Name],

[Supplier/Minimal Quantity],

[Supplier/Delivery Lead Time],

[Expense Account/Name],

[Income Account/Name],

[Supplier Taxes/Tax Name],

[Customer Taxes/Tax Name]

FROM

(ooxml, embedded labels) where WildMatch(DESC, '*HS25*', '*HS 25*' , '*HS-25*' ,'*LONG*');

I need to exclude DESC line item if it contains '*PR24*' or '*PR-24*'or '*PR 24* or '*SHORT*'

How do I change the WildMatch code?

Thanks

Re: Exclude in Search in a Load Statement

MK_QSL — Mon, 26 Jun 2017 08:57:22 GMT

where

(

WildMatch(DESC, '*HS25*', '*HS 25*' , '*HS-25*' ,'*LONG*')

and NOT WildMatch(DESC, '*PR24*' , '*PR-24*', '*PR 24* , '*SHORT*')

)

topic Exclude in Search in a Load Statement in QlikView

Exclude in Search in a Load Statement

Re: Exclude in Search in a Load Statement