Exporting Cross tabs to two separate tabs in Excel

Question

Hey folks,

I'm currently working with one set of data and creating two separate tables. I'd like to export the two tables to the same excel doc on different tabs as I do not want to merge the two tables together. However, when I attempt to export them they end up in the same tab next to each other. Is there a way to split up which tab each table is displayed on?

This is my current workflow:

Thanks for the help!

Alteryx test.PNG

Qiu · Answer

@connorfromstearns 
Use the Change Entire File Path option in the output tool should do it.

1216-connorfromstearns.yxzp

DanielG · Answer

Hi,

(this may be a duplicate post, as I wrote something up and it didnt stick when I went to post it.  not sure if it will show up later)

You need two outputs one for each table.  Point to the same Excel document in each, but provide separate sheet name on each of the outputs.

Layer in a block until done to avoid lock-up of the Excel file.

Also, make sure the 2nd output doesnt have overwrite book setting selected, as you will lose everything from the first output.

Hope this helps.