Skip to main content
Question

Filter out tables based on their name (using prefix)

  • November 1, 2022
  • 1 reply
  • 39 views

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
  • 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.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings