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

Group Query.xlsx

Workflow

Accepted answers

atcodedog05

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 : )

banks.yxmd

All comments

Jean-Balteryx

Hi @anitamarie2020 ,

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

Here is a workflow doing it !

multiple_file.yxmd

atcodedog05

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 : )

banks.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703