ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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