how to generate all the result into one single excel file?

[ASHccccc]

i wrote a flow for my team these days,  Alteryx will read a single  report and there are  4 data flows worked at the meanwhile and generate the results accordingly, but  how could I output these results to a single excel as well? I want them to output in one excel file but in different sheet, how to do that???pls helppppp~~~~

[Qiu]

@ASHccccc 
You can use the option in Output Data tool as below.
Create  field and make a full path for each tab.

[binuacs]

@ASHccccc As @Qiu mentioned union all your result and create a sheet name field using the formula tool  and update your output data with the below configuration Attaching a sample workflow for your reference

[grazitti_sapna]

@ASHccccc, if you have the same schema for all the outputs then you can union the data and use the output tool and the field name on which you want to group data and display it in a separate tab. Please refer to the screenshot below for configuration.

Thanks!

[ASHccccc]

hi @grazitti_sapna thx for your response, but sorry that their schema are totally different.... that's why I think union tool is not appropriate、、、、😣

[grazitti_sapna · Accepted solution]

@ASHccccc, can you try something like this as you have a different schema each time.

Thanks!