Alteryx Designer Desktop Discussions

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

Copying a template file

sbackhouse
6 - Meteoroid

Hi Alteryx Community

 

As a newbie to Alteryx I was hoping for some help with a basic query. I have seen similar posts already but none seem to quite work for me!

 

Its a simple one hopefully so here goes...

 

I want to take a file saved in my desktop (it is a macro enabled excel file with a .xlsm extension and I want to create 20 copies of the same file with 1,2,3 etc at the end of the filename.

 

It is important to preserve the .xlsm as once I have pushed data out to each separate file I want to be able to open them and then run the macros.

 

Many thanks in advance.

 

Steve

5 REPLIES 5
Qiu
20 - Arcturus
20 - Arcturus

@sbackhouse 
Just as you have tagged, we can use a run Command tool to do this.
A quick sample is 0630-sbackhouse.PNGas  below.

 

messi007
15 - Aurora
15 - Aurora

@sbackhouse,

 

You can do that using Blob tools :

 

Please see below :

 

messi007_0-1656576460351.png

 

 

Attached the workflow,

Regards,

Qiu
20 - Arcturus
20 - Arcturus

@messi007 
It seems that I am a bit out of date.
The blob tool seems better.

sbackhouse
6 - Meteoroid

Many thanks, worked well!! Thanks for such quick responses.

messi007
15 - Aurora
15 - Aurora

@sbackhouse,

 

Could you please my answer as a solution :) It will help others.

 

Happy to help,

 

Regards,

Prime Analytics loves Alteryx.png

Labels