Different Tables to different sheet in one file, but Block tool is not enough

Hello guys,

Is it possible to save different tables to different sheets in one excel file? I know I could use the Block Tool but I want a efficient way to solve this problem and not to copy every part of this workflow again.... The image show only an example, which I created quickly
Thank you for your help

Output

Database Connection

Accepted answers

Yoshiro_Fujimori

@Inactive User ,

If the Sheet name of each table is known,

I would add the sheet name to a new field, and put the tables together with Union Tool.

and then use the sheet name field in Output Data Tool.

Does it work for you?

OutputToSheets.yxmd

All comments

binu_acs

@Inactive User When you say table are they different excel files? If yes the a batch macro would be a solution for your use case

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

unknown

This is not my case.
Maybe I have to explain it more in detail.
I import a file on which I apply various filters. These parts I want to save in an Excel file. But for each table that I have filtered, I want to save in a sheet.

Yoshiro_Fujimori

@Inactive User ,

If the Sheet name of each table is known,

I would add the sheet name to a new field, and put the tables together with Union Tool.

and then use the sheet name field in Output Data Tool.

Does it work for you?

OutputToSheets.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703