Is it possible to keep the source row ID with the data throughout the transformation, and then use a feature (or dataset depending on your output type) fanout to write to the different files?
Another option would be to use a command line script (vbs, perl, python, whatever) that queries the database and loops through the results, sending the numeric value to your script as a parameter. Finally, you might be able to have a "driver" workspace and a "process" workspace. The driver workspace would, for each feature, run the process workspace with parameters extracted from your source dataset. I haven't tried this myself though, and can imagine bad things happening (like 100 fme processes running at once) :) Jason -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of snelsons2006 Sent: Wednesday, December 13, 2006 14:36 To: [email protected] Subject: [fme] Create a Looping FMW Hi again all, sorry for the three posts in as many days, but trying to do some things for the first time using FME. I have an FME that reads a personal GDB table. It starts off by reading a table, and I use an Attribute Filter to manually filter out one record based on a number in this table's field. Depending on what the value is of this filtered record, the FME uses this value to start doing multiple joins and outputs a final file containing certain values/info. Do you know a way to run this FME so that it reads this first table (single sourcedataset), and cycles/loops through so that it runs/processes/outputs a file for each record in this table??? So if the table has 100 records, I would run the FME and it would read the first record, process it, and spit out a file, then it would read the next record, process it, and spit out a file - and so on.....ending up with 100 output files. I've never used TCL before, so if this is possible in FMW that would be ideal. Could I use the Looping transformer to do this? For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
