Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities 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