Question

Using IN operator with tester transformer

  • 12 February 2024
  • 2 replies
  • 23 views

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

Userlevel 2
Badge +18

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.

Userlevel 3
Badge +24

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

Reply