I have a FME project reading information from an API and writing to an excel file. In the project i have a tester that tests if the data belongs to a certain organization. The organization list might expand, so I want the tester read this data from a (excel) file. How can I do this? Can I loop the project from the tester and write to different files?
Thank you for any views on this.
If you have a list of organisations in an excel file there are a number of ways you can use this file to filter the data, e.g. featuremerger, featurejoiner, databasejoiner.
If you then want to write separate files based on this organisation you can use a fanout on the writer
If you have a list of organisations in an excel file there are a number of ways you can use this file to filter the data, e.g. featuremerger, featurejoiner, databasejoiner.
If you then want to write separate files based on this organisation you can use a fanout on the writer
Thanks ebygomm! I will look in to that! Have a nice weekend.