Combining two different outputs into one xlsx in different sheets

[Cesc]

Hello, I'm trying extract two outputs in alteryx into two sheets of one single excel. I don't find the way to do it. Could you help me? Thx

[messi007]

@Cesc,

Please take a look on this post : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-output-multiple-tabs-within-a-s... 

You can use a formula Tool to create the path with the sheet name and after you use it in the output tool :

Attached the workflow,

Regards,

[atcodedog05]

Hi @Cesc 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[saveeshkumar]

Hi @Cesi 

Hope this will be helpful.

Thanks.

[Cesc]

For example, in the case @messi007 shared, i would like to extract an excel with two Sheets.

The first sheet would have 

Record    A       B

1              1       2

The second sheet would have

Record    A       B

1              3       4

[atcodedog05 · Accepted solution]

Hi @Cesc 

Configure the output tool like below

Hope this helps : )

[Cesc]

Thank you. So, for what I understand, first you put all fields togheter with a column that differentiates all the sheets that will have the excel and in the output, you tell alteryx how to differentiate the Sheets. Thank you everyone!

[atcodedog05]

Happy to help : ) @Cesc 

Cheers and have a nice day!