Error in using Run Command to move .bak file

Question

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
ame 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?

Control Container Screenshot.jpg

Run Command Configuration.jpg

fmvizcaino · Answer

Hi @BethHembree ,

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

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