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
View original
+10
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
+36
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!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
