Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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