Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Rendering multiple tables onto separate tabs of the same Excel spreadsheet

avalachovic
5 - Atom

I am trying to render multiple tables onto the same spreadsheet but want to keep them on separate tabs. I know how to create multiple tabs using the "Output Data" tool but I would like to keep the table formatting. Is there a way to do this?

1 REPLY 1
griffinwelsh
12 - Quasar

@avalachovic  one approach is to output the formatted reports to separate files and then use a python script to merge the workbooks. See the below thread if you are interested in this approach.

 

https://stackoverflow.com/questions/74646115/merge-all-excel-files-into-one-file-with-multiple-sheet...

Labels
Top Solution Authors