Skip to main content
  • EN

Hello all,

I have a large number of points (over 15,000) in the same geographical (x,y) location that I need to filter out. I cannot do this spatially and there is no coordinate data in the points. There is only one attribute within the data I can use to filter on (Address).

I have a spreadsheet that has a "Town" column that has over 3500 rows.

Is there anyway of bulk testing the Address attribute against the Town column from the spreadsheet to filter down the data? I don't want to copy and paste 3500 Town names into a Tester if I can avoid it!

Thanks,

Jeff.

Hi @juffers,

You can use the DatabaseJoiner transformer to join your data to the spreadsheet Town column. Any features that do not find a match will be output through the Unjoined port of the transformer, making it an effective filter.

Thanks for the answer

Reply


Community Stats

31,821
Posts
120,861
Replies
39,451
Members

Latest FME

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.