Skip to main content
Question

Tester based on inputs from file


Forum|alt.badge.img+1

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.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • June 5, 2020

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


Forum|alt.badge.img+1
  • Author
  • June 5, 2020
ebygomm wrote:

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.


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