Configuration in Run Command Tools

Hi All,

I have an Alteryx workflow that contains Run Command Tools.

However, it will automatically pop-up a Windows cmd.exe interface when the workflow runs to the run command tool, which asks me "Would you like to replace the existing file?".

I have to enter "Y” a couple of times in the pop-up Windows cmd.exe interface to proceed the remaining part of the workflow.

Therefore, I would like to know, whether Alteryx can finish the above manual action. So, the workflow can be run automatically.

Thanks all of you.

I have attached the cmd.exe windows and the configuration of run command tools in this post below. 圖片2.png 圖片3.png

Workflow

Input

Reporting

Regex

Macros

Date Time

Help

Join

Download

Scheduler

Run Command

Power BI

Accepted answers

flying008

Hi, @tamluenwai29

You can try change your code part , from

"C:\Program Files\7-Zip\7z.exe" e "C:\Program Data\Alteryx\***.zip"

"C:\Program Files\7-Zip\7z.exe" e -y "C:\Program Data\Alteryx\***.zip"

All comments

OTrieger

@tamluenwai29
It will be much easier to ensure that the folder is empty or that you are writing out the data to a different folder.

tamluenwai29

Could you give me some insight for writing out the data to different folder?

But I am still want to know how to solve the problems that I mentioned in this post! Thanks a lot !

SPetrie

What command are you running that prompts the window? Those commands usually have switch parameters you can add to force overwrite such as -Y or /Y etc. It may be beneficial to lookup what options are available for you command and add them in.

tamluenwai29

Hi @SPetrie, after 2 weeks, I still haven't figured out how to do this. Could you give me some help for this problem?

Attached the sample workflow and dummy data in this reply down below.

Set Up Cmd:

pushd "%~dp0"

mkdir Extract

pushd Extract

Post Cmd:

popd

dir /B Extract > ziplist.txt

popd

螢幕擷取畫面 2024-10-15 105439.png

Run Command Tool Configuration:

螢幕擷取畫面 2024-10-15 105553.png

flying008

Hi, @tamluenwai29

You can try change your code part , from

"C:\Program Files\7-Zip\7z.exe" e "C:\Program Data\Alteryx\***.zip"

"C:\Program Files\7-Zip\7z.exe" e -y "C:\Program Data\Alteryx\***.zip"

tamluenwai29

@flying008

Hi, after adding the "-y" in the formula tools, the windows pop-up screen is solved.

However, there is no data returned. Could you give me some insight?

螢幕擷取畫面 2024-10-15 121553.png

apathetichell

Have you tried the -y flag with the 7zip command line?

flying008

Hi, @tamluenwai29

There is 'e -y' 'have a space between 'e' and '-y', not as your write 'e-y', you can also change the code to "C:\Program Files\7-Zip\7z.exe" e "C:\Program Data\Alteryx\***.zip" -y

tamluenwai29

@flying008

Thanks so much! it works!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703