Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Overwrite an excel while retaining the original copy

Isha_Gupta
8 - Asteroid

Hello,

 

I have a workflow in which I am overwriting an excel template in a specific range while preserving it's formatting.

 

Is there any way that I can keep the original template as is in the folder while also overwriting it and saving it as another file name preferably Current Name_Month_Year.

 

So my file 1 which is empty template is one which I give in output path with overwrite settings, but the output I get is file 2 with above name while retaining the file 1, the empty template, which I can re-use next month without any change.

1 REPLY 1
apathetichell
20 - Arcturus

template file location in text input -> blob input. formula tool to create new file name -> blob output. you now have a copy of your template to write over.

Labels
Top Solution Authors