Skip to main content
Question

tester loop through values

  • April 4, 2014
  • 2 replies
  • 42 views

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? 

 

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

fmelizard
Safer
Forum|alt.badge.img+22
  • Safer
  • April 5, 2014
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
Safer
Forum|alt.badge.img+22
  • Safer
  • April 6, 2014
typo : fanout....

 

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