Skip to main content
  • EN

Hi there,

 

I am applying a filter on record using tester transformer. My test clauses contains multiple And/OR conditions. I have attached screenshot of the test clauses. The problem is tester does not filter the record the way I wrote the condition. For example, I dont want to include the record in which CAUSE attribute has value 2A or 2B. However, in the tester passed category contains the record that has CAUSE value of 2A or 2B. Similarly, I do want to include the record in which the description attribute contains the value "BLOWN LV FUSE". However, passed category does contain those records. Could anyone guide me where am I making the mistake?

The part that has CAUSE != 2A OR CAUSE != 2B is always true.

I think that needs to be CAUSE != 2A AND CAUSE != 2B

Same issue with the DESCRIPTION (should be AND).

The Tester has an option to do: AND NOT DESCRIPTION Contains <value>.

Hope this helps

The part that has CAUSE != 2A OR CAUSE != 2B is always true.

I think that needs to be CAUSE != 2A AND CAUSE != 2B

Same issue with the DESCRIPTION (should be AND).

The Tester has an option to do: AND NOT DESCRIPTION Contains <value>.

Hope this helps

Thanks for the clarification. Just a follow-up question. Can we enter all values of description in a single contain operator? If yes, then how do we separate the values (comma, or double quote)?

Thanks for the clarification. Just a follow-up question. Can we enter all values of description in a single contain operator? If yes, then how do we separate the values (comma, or double quote)?

You can use the IN operator to do so.

Have a look at the Help for the Tester here

Reply


Community Stats

30,176
Posts
114,541
Replies
37,835
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.