community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Output tool

Asteroid

Hi,

 

I have used block until done tool to write multiple output into same excel file as indicated in attached snapshot. The issue is I tried renaming the sheet names instead of having it as sheet 1,2,3 but the output includes 6 tabs which is sheet 1,2,3 and exact duplicate of those sheets but named sheets. Please see attached file. Is there a way to eliminate additional sheets and just have named sheets? Thank you!

Alteryx
Alteryx

Just delete the existing Excel sheet and then run the workflow again. The output tools are set up to just overwrite the sheet names that have been specified, so they won't touch the existing ones. If you delete the file and run the workflow it will create the sheets that you have specified. 

Alteryx
Alteryx

@aparna0208 If the information in the existing file is created by the workflow, I would just delete the excel file and run the workflow. Make sure in the output data tool, you have Overwrite Sheet (Drop) set for all the output data tools. This will make sure that specific sheet is updated at runtime. 

Digan
Alteryx
Highlighted
Asteroid

When I delete the file and run the workflow then it works. And yes, I already have Overwrite Sheet (Drop) set for all the output data tools. Thank you so much for the quick response:) @BrandonB @DiganP 

Labels