Use Run Command tool to copy a template file Alteryx

Question

Hi everyone,

I'm using Run Command tool to replicate a template file but I have some troubles with this.

The path folder is always error although I have tried many paths. My original folder is "Template.xlsx" on path D: \Alteryx\Persistency\Run Command\Output and I want to create a copy file of this template named "Result"

I have attached my workflow and template file below. Could you please help me correct this error?

Thank you so much!

Run Command.yxmd

Template.xlsx

ArnaldoSandoval · Accepted Answer

Hi @anhnguyenngoc2002

Please take a look at the attached workflow:

Notes:

* Added Block Until Done to manage workflow flow, first Run Command, then Write to the Result.xlsx file.
* Look at the configuration of the Run Command tool; it creates the file "Run Command.bat" in the Output folder; the run the "Run Command.bat" from the output folder; the batch file does the copy.
* Check the write something to the "Result.xlsx" files; the formula define the target sheet, and the Output data configuration define how to handle the output.

Hope this helps,

Arnaldo