Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to Create a new Excel sheet after every run

MostafaBouzari
8 - Asteroid

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. 

 

2020-05-05 (6).png

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

 

How can i Solve this?

 

Regards

1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor

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

Labels