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

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~~~~

Output

Accepted answers

grazitti_sapna

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

Thanks!

ASHccccc_workflow.yxzp

All comments

Qiu

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

binu_acs

@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

union_21_07.yxmd

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、、、、😣

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703