Free Trial

Alteryx Designer Desktop Discussions

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

Can output tool add a new output sheet to existing excel file?

jportello
8 - Asteroid

Hi everyone! I have a mapped data set output from alteryx that I would like be written to an existing excel file that has sheet in it already. I would like alteryx to make a new sheet in the excel with the data output from the workflow. Is that an option?

2 REPLIES 2
Deano478
12 - Quasar

hey @jportello yes this is possible just drag on a new Output Data Tool Select the Excel Workbook you want to add the sheet to and set the Output Options to Create new Sheet and then run it. NOTE: You may need to use a Block until Done tool if writing multiple outputs at the same time to this workbook.

aatalai
14 - Magnetar

yes  as long as the sheet name is new, select create new sheet in the settings

 

Let me know how you get on

 

create new sheet output.PNG

Labels
Top Solution Authors