nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Configure Run Command tool to move a file

AndrewW

I have a number of files in a directory, some of which I'll process, some of which I won't, but all YXDBs. Once all of the files I want to process have been processed then I want to move them to a different directory (or maybe delete, still TBC). I can do this using the command prompt.

The difficulty I'm having is how to run the command prompt, how to configure the Run Command tool. Apparently it needs either a Write Source or Read Results, I can't think what these could be to run a command in the command prompt.

I'll actually be generating the list of files to move into a list and am comfortable using a macro to alter the Command Arguments to dynamically load the command line details. What I don't know how to do is to get actually get the Run Command configured.

Note I've seen this prior question on a similar note, http://community.alteryx.com/t5/Data-Preparation-Blending/Using-Run-Command-to-Move-files/m-p/8958, but I prefer to do the Run Command mid-workflow and not use the Events if possible.

Frustratingly I'm unable to upload my 19kb screen shot of the current Run Command configuration so to describe I have entered "cmd" in the Command section and the correct arguement in the Command Arguments [Optional] section, which gives the error "Either an Output connection or Input Connection is required"

Run Command

Accepted answers

s_pichaipillai

Andrew

Try this one too. this will generate the Move comman batch file at temp path and move the files to the spcefied firectory

i enabled full path in Input configuration

Move Files.yxzp

All comments

michael_treadwell

Andrew, scroll down and check my post in this thread to get a better explanation of what is going on in the Run Command tool and how it should be configured: http://community.alteryx.com/t5/Data-Preparation-Blending/Run-a-python-script-in-Alteryx/m-p/10999#M1855

It sounds like you have most of the work done if you can already accomplish the file move via the command line.

In your case, you don't necessarily need Write Source or Read Results but since Alteryx requires at least one you might consider having them write dummy .txt files.

s_pichaipillai

Andrew

Try this one too. this will generate the Move comman batch file at temp path and move the files to the spcefied firectory

i enabled full path in Input configuration

Move Files.yxzp

AndrewW

Thanks for the response Michael. Not there yet and I'm confused why. I created a Dummy.csv as my Input (Write according to the Run Command tool) and that allowed it to work - ot at least the cmd prompt opened. The Command Arguments weren't moved into the command prompt. It actually does nothing apart from open the command prompt and then spinds in the Run Command icon on the workflow until I manually cancel. The command prompt remains open but doing nothing during this time.

I restested and the 'argument' entered should work, at least it does when I enter into the command prompt opened by Alteryx when trying to Run Command. Is this anything you come across before?

Any ideas?

apathetichell

what's in Cmd3? Can you autofield it before your run command, or change the string type? Is it really that huge?

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703