How to Create a new Excel sheet after every run

Question

Hello everyone,

I have a Workflow and i want to output in every run an Excel sheet with new Data. The Problem is that it gives me an error when i want to Create new one when already existed. (Output Confiquration: Create new Excel file)

The excel File Consist of some Tabs.thease tabs will get changed based on the user's choice. That means some of them should not exist when user deosn't selects them. but with other options (Like:Append to...,Overwrite...) in Output tool i can not achieve this.

(Containers get disabled if a user doesn't select it)

How can i Solve this?

Regards

fmvizcaino · Accepted Answer

Hi @MostafaBouzari ,

So what you need is to be able to delete all the sheets you don't need from a file or to somehow erase the whole files before the workflow runs in order to create only the sheets the user selected, right?

For that, I would suggest you to use a run command tool to erase the file prior to its creation, it could be anywhere before your output data tools.

Explain how to do it: https://www.theinformationlab.co.uk/2017/08/10/delete-files-alteryx-cleaning-computer-part-1/

More about run command tool: http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Run-Command/ta-p/31548

Best,

Fernando Vizcaino