How to output tables to different excel tabs

Question

I am created tables, and each table has a month name, so:

January Table1

February Table2

etc

I want to create 1 excel file with these tables as separate tabs, I'm using the reporting Table tool to create these since I want to use row formatting to highlight anomalies, I cant figure out how to do this!

DataNath · Accepted Answer

Hey @craigja - I wrote up a blog on this a while ago which outlines the steps needed to achieve this. You can find it here: https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015093