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
Hi @Cesc
Configure the output tool like below
Hope this helps : )
@Cesc,
Please take a look on this post : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-output-multiple-tabs-within-a-single-Excel-file-based-on/td-p/507828
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,
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 : )
Hi @Cesi
Hope this will be helpful.
Thanks.
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
1 3 4
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!
Happy to help : ) @Cesc Cheers and have a nice day!
