Output - Split

[anitamarie2020]

Hi Team, 

Just wondering could anyone advise on a query I have. I have two tabs - Is there a way that I can create a seperate excel output for each Email group. For example - Can I Split it out so that the output comes out with two tabs but it's just one bank. So by the end I hope to have 4 separate outputs Bank A, Bank B, Bank C and Bank D

Thanks,

Anita

[Jean-Balteryx]

Hi @anitamarie2020 ,

You can write in different files based on a column using Output tool.

Here is a workflow doing it !

[atcodedog05 · Accepted solution]

Hi @anitamarie2020 

You can create a column which is a combination of filename and sheet name like below which will output to different files and 2 sheets.

Workflow:

You can also give the path before filename.

And you need to configure output tool to change entire path based on filename.

Hope this helps : )

[anitamarie2020]

Thank you so much Both,

@atcodedog05 for some reason when I run the model it's only giving me one tab in the output. Whereas I would require 2 tabs - one for Open and one for settled.

[atcodedog05]

Hi @anitamarie2020 

Make the output option is overwrite sheet and not overwrite file.