cross tab table into excel sheet

[troy_mech]

I have three separate cross tab table data in a workflow. I want to export each cross tab output into each separate sheet in single excel file. So whenever I'm running this workflow those three sheets need to be overwritten.

[joshbennett]

@troy_mech 

I would suggest just adding an Output Data tool after each Cross Tab, and specify the same directory / filename for your desired Excel output, and then just configure the sheet name immediately following the ".xlsx" in your output fullpath to be "|||SheetName" (renamed to whatever sheet names you need.

Using a Block Until Done between your Cross Tabs and your Output Data tools will ensure you do not encounter any errors from trying to write multiple outputs simultaneously for the same file.

See attached for example - hope that helps!

[troy_mech · Accepted solution]

Thanks for your answer. I have added the block tool before the report however your suggestion works.

I have mentioned my workflow below,

[joshbennett]

@troy_mech Nice! Yes, you can use the Block Until Done tool in that way too (assuming your data exists in a single data stream at one point so you can pipe it through Block Until Done. If you have separate data streams, you can use the approach I mentioned of just adding separate Block Until Dones before each output.

Glad you got it working (please mark as solved if you get a chance).