Skip to main content
Question

Filter out tables based on their name (using prefix)

  • November 1, 2022
  • 1 reply
  • 78 views
A

I'm using a Geometry filter split out points, lines, polygons and tables (<unfiltered>). With the tables, I'd like to filter them further to split up the tables that begin with the prefix "Insp_" or "Maint_", because I want to exclude those from the rest of the script. I can only seem to figure out how to filter based on Attribute, but I can't figure out how to filter based on table name. Any suggestions would be greatly appreciated. Thanks!

1 reply

f.kemminje
Contributor
Forum|alt.badge.img+11
  • f.kemminjeContributor
  • Contributor
  • November 2, 2022

Is the table you refer to an Oracle table or another type of database table?

The table name will be in the fme feature type attribute, which you should expose using attribute exposer.

As an alternative, you can add a Breakpoint ((unfiltered >) connecting line) after the Geometry filter.

Now have a look at the content window and search for attribute name which contains name  "Insp_" or "Maint_",  and filterit out.

 

f.kemminje

Community Stats

32,763
Posts
124,242
Replies
41,288
Members
Terms & ConditionsAccessibility statement
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.