Preventing an obsolete item from loading in QlikView script

[NickBentley]

I am loading sales figures from a data set that now includes obsolete items. How do I prevent the items from loading  in the script where the item number is 'Obsolete' 

Sales_Data:

LOAD
Store_Number,

Item_Number,
Item_Category,

Thanks!

[mpc · Accepted solution]

Hi,

You can use:

Sales_Data:

LOAD
Store_Number,

Item_Number,
Item_Category
Where Not(Wildmatch(Item_Number, 'Obsolete' ));

Kind regards

[NickBentley]

Thanks  maximepiquetcointe! 

Works as expected.

PREVIEW

[BrunPierre]

Hi, as below.

FROM ...
Where Match(Item_Number,'Obsolete') = 0;