Solved

Filter data based on multiple columns

Forum|Forum|3 years ago
November 17, 2021
4 replies
217 views

rob_nason
14 replies

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.

Best answer by drc43

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.