Alteryx Designer Desktop Discussions

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

Use Run Command to Copy File and append Date

lvb
5 - Atom

I want to use the Run Command tool to copy a file that is an input file for my workflow into an archive and add a specific text and the current date to the filename.

 

I used the following tools:

Text input: To input the text "24Q4" (Field name "Quarter")

Formula: To add the current date and file extension to [Quarter], so that it then reads "24Q4_2024-09-05.xlsx"

Run cmd: I want the workflow to take a file from a source (say my desktop) and copy it to another location, adding this to the filename.

I used a message tool send a message when done.

Although the Run cmd tool has an input and output connection, I get the following error on the tool: "Either an Output connection or Input connection is required."

Can you help with setting up the Run cmd tool?

2 REPLIES 2
OTrieger
11 - Bolide

@lvb 
Normally the way how I will use Run Command tool will be as follow.
I will create the Command in Formula tool. Then in the Run Command Tool I will set the Write Source and the Command.
Both with the same path to the .bat file
And I do not get any errors

OTrieger
11 - Bolide

bat.PNG

Labels