We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
SOLVED

Run Command error code 1

lseiler
6 - Meteoroid

Hello all,

 

I have a workflow that generates a formatted .xslx-file with the Render-Tool. So far so good...I need to encrypt the file.

I use the "msoffice-crypt"-tool to decrypt my files. It works fine when I use the command line by manual.

I use following command:

 

 

 

 

msoffice-crypt -e -p password "\\servername\datapath\file.xlsx"

 

 

 

It works absolutely perfect in the windows command line.

 

I generate the same command in alteryx with the formula tool, put it in a command.bat file and use it in the "Run Command" tool.

The flow throws a "The external program "command.bat" returned an error code:1" error.

 

here is a screenshor from the Run Command tool:

lseiler_0-1650619459575.png

 

msoffice-encrypt.exe, the workflow and the command.bat are in the same directory.

The Working DIrectory is the directory with all my files.

Write Source is a file named "command_out-bat" in the same directory.

The command is the bat-file in the working directory.

 

Can someone help here?

 

Thank you in advance!

1 REPLY 1
lseiler
6 - Meteoroid

This is solved. I just inserted the tool as a new tool again and it works now.

Labels
Top Solution Authors