Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Error in using Run Command to move .bak file

BethHembree
6 - Meteoroid

Hello,

 

I am trying to use the Run Command Tool to move the .bak file from where it lands to an alternative folder due to PoweBI unable to ignore .bak file. 

 

My current error is "Either an Output connection or Input connection is required"

 

I created a bat file with (changed current name for this question)

move /y "C:\Users\location of file where it populates\*.bak" "C:\Users\where I want the file to move to\Workflow Backup\"

 

For the run command, I have command as cmd. 

Command Arguments, I have  /c "C:\Users\where I want the file to move to\Workflow Backup\name of bat file"

Working Directory, I have C:\Users\location of file where it populates\*.bak

 

I've included screenshots. I have the tool in a container to run at the end of the worfklow. I added a dummy text input file and ended with a Browse tool while I was working through the errors. Any advise?

1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor

Hi @BethHembree ,

 

You need either an output created or an input read in the run command tool (don`t ask me why).

 

Screenshot 2025-02-07 124228.png

 

I usually use the input to build a dynamic bat script, but in your case, since your bat script is always the same, you can do something like the image above.

Also, remove the browse tool from the run command output. If you wanna connect a browse tool, you will also need to configure the read results portion to open an input file.

 

Here you can find more about the run command tool: https://community.alteryx.com/t5/Tool-Mastery/Tool-Mastery-Run-Command/ta-p/31548

 

Best,

Fernando Vizcaino