Question

Using IN operator with tester transformer

  • 12 February 2024
  • 2 replies
  • 43 views
derekg
Rank
Badge +1

I have a list of lab test results and only want to include the rows that match a list of analytes. I am trying to use the IN operator in the tester transformer.

I have followed the advice from this post:

Help with syntax when using Tester transformer | Community (safe.com)

This is what I have:

Sheet1 contains the test results, text_line_data contains the list of analytes as one feature. I have merged them to get this:

 

The “text_line_data” column looks like this:

 

My tester transformer is set up as below:

 

However, all rows fail the test. What am I doing wrong?

 

 

2 replies

oscard
Rank
Userlevel 2
Badge +21

The IN parameter takes a comma delimited list: A,B,C…

You also need to remove the quotation marks from the list. Do that first and then use an Aggregator transformer to create the list separated by commas.

redgeographics
Rank
Userlevel 5
Badge +32

I think the Contains operator, rather than In, does what you want (if you swap the left and right values)

Reply


Community Stats

29,355
Posts
111,609
Replies
37,018
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.