Output file tabs

[nataliad18]

No idea if this is possible... but it seems like such a straight forward thing, so i hope there is.

SO, here is the idea:

I need to create an output in excel with multiple tabs. The multiple tabs (and the amount of the tabs) is dependent on something earlier in the workflow, where i grouped by something. 

So, lets assume we have a column "country". If i did group by country, then in the summarise tool, i got for example:

France

America

Canada

Sweden

Japan

Can i link that summarise tool somehow to the output file (or reporting, or whatever it may be), to name the tabs accordingly? 

IF THAT IS POSSIBLE (then firstly, yay!), then 2nd question, is there a way to link the tab to the *correct* data? 

I.e earlier in the workflow i will have to separate all data for the 5 countries above, and i would need the output files tab name match the country data in the tab?

Thanks a million!
Natalia

[JosephSerpis]

Hi @nataliad18 yes it is possible have a look at this article which explains how to do it.

[PhilipMannering · Accepted solution]

Here's a very simple example for reference,

The trick is to create the filepath using the data. Then update the output file path in the Output Data Tool. The example should be easy to modify to your needs.

[nataliad18]

Thanks @PhilipMannering - simple and clear :)