In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Add a separate sheet to Excel Files which are created with Table/Render Tool

Teresa3
6 - Meteoroid

Hi Community,

 

I have a dataset with different information and Countries. I run this through my workflow and create 1 file for each country with the table and render tool. 

 

But what I need is: I need a separate sheet in each file called "Template" with headers which differ from the headers in sheet1. The Template only contains the headers and nothing else and the sheet should be named "Template". 

 

I don't understand how I can add this sheet to the files before they are put out. 

 

Maybe you can help please. 

 

Thank you in advance!

2 REPLIES 2
StellaBon
11 - Bolide

Hi Teresa3,

Please take a look at this Interactive Video, that should give you some guidance on how to do this:

Writing to Multiple Outputs 

 

Take a look at the final segment of the Lesson, Writing to Multiple Outputs.

Hope this helps!

StellaBon
11 - Bolide

Let me know if this worked!

Labels
Top Solution Authors