One excel for various excel output from Render

Question

Hello Guys, please guide me on the below..

In a single project, I have 4 excels output from 4 Render tool..

All 4 excels have a single sheet and it contains data in table form.

Which tool or function I can add after or before Render so that I will get only one excel output instead of 4.

And this 1 out will contain data in 4 different sheets..

Cheers

apathetichell · Answer

What kind of ouptut are you putting into the render? Tables/Charts etc?

You can use the reporting tool palette to put your workflow into four tables/charts/etc and then use union to combine them - then put them in render.

NOTE:

you may have issues in page sizing/formatting if you have differing amounts of columns and differing widths on the tables you are placing into excel. Obviously this is not the case if you are using a filename/path option to create differing sheets.

Here's a general article on using filepath/name to output to separate sheets in the same file.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Modify-File-Name-for-Multi-Tab-Excel-Workbook/ta-p/95673