Skip to main content
Question

Tester transformer does not produce the desired result

M

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?

3 replies

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • January 21, 2020

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

M
erik_jan wrote:

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)?

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • January 22, 2020
muhammad_yasir wrote:

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


Helpful Members This Week

Community Stats

31,188
Posts
118,232
Replies
38,798
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.