Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
12 - Quasar

@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
12 - Quasar

bat.PNG

Labels