Question

tester loop through values

  • 4 April 2014
  • 2 replies
  • 2 views
M
I have a script that currently uses a user supplied ID value to search through four different geodatabases for features with the requested ID and updates data in an Excel file with the found features.  It's quite simple: each geodatabase with its own Tester, the Right Value set to the appropriate parameter, all writing to a separate tab in an Excel writer which uses a template file.

 

 

What I'd like to do is modify so instead of the user entering a single ID to search for, it can loop through  multiple IDs in a table to look for and create an excel file for each ID.  How I imagine it would work is to pass the values from a table one at a time to the Tester transformers.  However, I'm still quite new to FME and I have no idea if this is possible. 

 

 

Does anyone have any thoughts on how this might be accomplished? 

 

 

2 replies

fmelizard
Rank
Userlevel 4
Badge +13
Hi,

 

I would change the testers with a SQL executor with a where IN clause.

 

You can create the IN value by aggregating the id's. Once the features are returned use a fanoit .
fmelizard
Rank
Userlevel 4
Badge +13
typo : fanout....

 

optionally a FeatureReader per gdb with a where IN clause is also a possibility.

Reply


Community Stats

28,723
Posts
109,510
Replies
36,559
Members
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.