Skip to main content
  • EN

As an example, in Excel you would use the filter function and select specific values from the drop down menu across multiple columns.

 

How in FME do you filter rows of data based on attributes held in multiple columns?

 

I've looked at the two SQL translators; SQLCreator and SQLExcuter but both need connecting directly to a database. In my case I need to use the transformer within my workflow.

 

Thanks.

You can use a Tester transformer with an AND or OR (or other) logic on multiple rows in the transformer to 'test' multiple fields.

http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/tester.htm

Or if you absolutely want to use SQL, take a look at the InlineQuerier.

You can use a Tester transformer with an AND or OR (or other) logic on multiple rows in the transformer to 'test' multiple fields.

http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/tester.htm

Thank you that's perfect.

Or if you absolutely want to use SQL, take a look at the InlineQuerier.

I'll keep this in mind for the future!

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.