Run Command Hangs the Workflow

I'm using the "run command" tool to SSH into a remote linux machine hosting a database I wish to work from in Alteryx. I wish to automate this login process so that I don't need to do so manually each time I run the workflow.

Whilst the run command works and successful opens the connection to the remote machine, the workflow pauses and will not process downstream until I close the window which was opened by the run command tool.

I am passing the command

putty -load "mysession" -pw mypassword

Is there a way to prevent the run command tool hanging the workflow in this way?

Run Command

Accepted answers

King

Hi Chris,

The batch file just contained the string:

putty -load "mysession" -pw mypassword

However, from following various chains from the posts you directed me to I found a solution. I changed the command string to:

start putty -load "mysession" -pw mypassword

Adding "start" seems to open the terminal and close the original command window and return to the workflow 🙂

Regards,

Charles.

All comments

ChrisTX

I've seen many people create a BAT file then run that.

Here's an example, writing the BAT file to the %temp% folder:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Move-jpeg-files-to-different-folder-depending-on-file-names/m-p/90362#M6589

Chris

King

Thanks, I should have clarified the configuration I am using. I've set this up to write a batch file an execute this. The file runs okay, the SSH terminal window opens and connects then the workflow is just stuck "running" until I close this:

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703