Running powershell query on Alteyrx

Hi,

I was trying to run below query on Alteryx to unzip a file

'Expand-Archive -Path '+"'"+[FileName]+"'"+' -DestinationPath '+"'"+[User.Path]+"\'"

translated to

Expand-Archive -Path 'Networkpath\Zipped\Data.zip' -DestinationPath 'Networkpath\data\'

This works if open Powershell in the path where zip file is located and run the code. But when I try to run with Alteryx with below configuration, its throwing error and just opens Powershell as below. I feel its not pointing to correct folder as when I do the same manually. Could someone help me to fix the configuration?

Workflow

Gallery

Developer Tools

Server

Help

Events

Accepted answers

OllieClarke

@Jaimon_office

You might need to bypass the policy which prevents scripts from running.
This is how I setup my runcommand tool to run a script I write to my temp drive.

The relevant bits are:

the Output (script.ps1 in the temp drive)
Command (powershell)
Command arguments (bypass the policy and then run the script)
Working Directory (the temp drive)

Hope that helps

Ollie

All comments

davidskaife

Hi @Jaimon_office

You need to have test.ps1 in the Command Arguments section, as that tells Alteryx where the script is to run - there is a KB article here on the basics - https://knowledge.alteryx.com/index/s/article/How-To-Use-PowerShell-with-Alteryx-1583460190246

MinhLO

@Jaimon_office

I believe your Run Command configuration is incorrect.

This is an example on how it can be configured:

Command should point to your powershell exe. Cammand Args should point to your script + arguments if you are providing any

I hope it helps!

Jaimon_office

Hi, Thanks for the tip @MinhLO and @davidskaife

I tried the method as suggested, but still getting error. Added the configuration setup below

OllieClarke

@Jaimon_office

You might need to bypass the policy which prevents scripts from running.
This is how I setup my runcommand tool to run a script I write to my temp drive.

The relevant bits are:

the Output (script.ps1 in the temp drive)
Command (powershell)
Command arguments (bypass the policy and then run the script)
Working Directory (the temp drive)

Hope that helps

Ollie

Quick Links

This months top contributors

FláviaB 262

caltang 177

DanM 167

IraWatt 157

gawa 157