Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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