Skip to main content
Solved

Loading a large amount of features to Test on?

J
Forum|alt.badge.img

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.

Best answer by daveatsafe

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.

View original
Did this help you find an answer to your question?

2 replies

daveatsafe
Safer
Forum|alt.badge.img+19
  • daveatsafeSafer
  • Safer
  • Best Answer
  • May 14, 2018

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.

J
Forum|alt.badge.img
  • juffers
  • Author
  • July 21, 2018

Thanks for the answer

Reply


Helpful Members This Week

Community Stats

31,184
Posts
118,190
Replies
38,794
Members

Latest FME

Terms & ConditionsCookie settings

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