topic Re: Multiple Or in Load in QlikView

Multiple Or in Load

leocattqv — Wed, 11 Oct 2017 16:53:28 GMT

Hi all,

I am trying to filter out records from loading using the where clause - I have more than one code that I dont want in.

I have tried multiple variations on:

Where([Failure Mode] <> 'OR06 - Shippping Issue')

OR ([Failure Mode] <> 'OR03 - Incorrect Quantity Sent') ;

I know this is a rookie move - but can someone give me a direction? its driving me crazy

thanks

-L

Re: Multiple Or in Load

Anil_Babu_Samineni — Wed, 11 Oct 2017 16:59:17 GMT

May be this?

Where Not WildMatch([Failure Mode], 'OR06 - Shippping Issue','OR03 - Incorrect Quantity Sent')

Re: Multiple Or in Load

sunny_talwar — Wed, 11 Oct 2017 17:15:37 GMT

Or may be you AND between them

Where([Failure Mode] <> 'OR06 - Shippping Issue') AND ([Failure Mode] <> 'OR03 - Incorrect Quantity Sent') ;

Re: Multiple Or in Load

uroboros — Wed, 11 Oct 2017 20:28:38 GMT

Okay, but he should use it better:
Where not Match([Failure Mode], 'OR06 - Shippping Issue','OR03 - Incorrect Quantity Sent')

For a better performance.

Re: Multiple Or in Load

MarcoWedel — Wed, 11 Oct 2017 20:54:00 GMT

Hi,

you might as well load your unwanted Failure Modes from a source you can maintain outside of your script code and exclude matching records using the Exists() function:

tabFailModExcl:

LOAD * INLINE [

excluded Failure Mode

OR06 - Shipping Issue

OR03 - Incorrect Quantity Sent

OR02 - Incorrect Product Sent

OR01 - Insufficient Product Quality

];

tabShipments:

LOAD RecNo() as ID, * INLINE [

Failure Mode

OR01 - Insufficient Product Quality

OR02 - Incorrect Product Sent

OR03 - Incorrect Quantity Sent

OR04 - Incorrect Color Sent

OR05 - Incorrect Size Sent

OR06 - Shipping Issue

OR07 - Due Date exceeded

]

Where not Exists([excluded Failure Mode],[Failure Mode]);

DROP Table tabFailModExcl;

(replace inline loads with you real sources)

hope this helps

regards

Marco

Re: Multiple Or in Load

MarcoWedel — Wed, 11 Oct 2017 21:02:40 GMT

or maybe like this:

mapFailModExcl:

Mapping

LOAD *, 0 INLINE [

excluded Failure Mode

OR06 - Shipping Issue

OR03 - Incorrect Quantity Sent

OR02 - Incorrect Product Sent

OR01 - Insufficient Product Quality

];

tabShipments:

LOAD RecNo() as ID, * INLINE [

Failure Mode

OR01 - Insufficient Product Quality

OR02 - Incorrect Product Sent

OR03 - Incorrect Quantity Sent

OR04 - Incorrect Color Sent

OR05 - Incorrect Size Sent

OR06 - Shipping Issue

OR07 - Due Date exceeded

]

Where ApplyMap('mapFailModExcl',[Failure Mode],1);

hope this helps

regards

Marco