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
19 - Altair

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