Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
You can use:
Sales_Data:
LOAD
Store_Number,
Item_Number,
Item_Category
Where Not(Wildmatch(Item_Number, 'Obsolete' ));
Kind regards
Hi,
You can use:
Sales_Data:
LOAD
Store_Number,
Item_Number,
Item_Category
Where Not(Wildmatch(Item_Number, 'Obsolete' ));
Kind regards
Hi, as below.
FROM ...
Where Match(Item_Number,'Obsolete') = 0;