Skip to main content
  • EN

Hi there,

I've never had to use the workspace runner before, and I'm kind of lost on how to set it up in the way I need it to function.

So currently I have a very simple workspace that is essentially just a SQLCreator and an Excel sheet writer outputting some measurement summaries. My SQL statement connects to a PostGIS database, which contains a list of per-country tables. All these tables are named the same (i.e. "France_full_2019", "Ireland_full_2019") except for the country name.

In this workbench I added a plain text parameter in the SQL lines instead of a specific country, so in this way, running the workbench, I can type "France" in the parameter window and get France's data. This all works perfectly fine and as intended, but of course limits me to 1 country at a time...

This is where my request comes in:

I want to know how to use the workspace runner to somehow input an entire list of countries and have it run the above mentioned workbench for each of list entries individually.

I've tried toying around with it but with little to no success...

 

Thanks in advance for any insight.

I don't think you need a workspace runner for this scenario. If you read in your list of countries, use the values to create an sql statement for each one and then use an sqlexceutor to execute the statement you will get outputs for all countries. As long as you keep an attribute that defines the country you can then use this as a fanout on the excel writer.

I don't think you need a workspace runner for this scenario. If you read in your list of countries, use the values to create an sql statement for each one and then use an sqlexceutor to execute the statement you will get outputs for all countries. As long as you keep an attribute that defines the country you can then use this as a fanout on the excel writer.

Works perfectly :). I Guess I overthinked it a bit and got stuck at an SQLCreator instead of just using the SQLExecutor.

 

 

Thanks a million!

Community Stats

31,940
Posts
121,315
Replies
39,557
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.