This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 08-24-201602:14 PM - edited on 04-22-201909:46 AM by SydneyF
Alteryx can use the Run Command Tool to run Powershell scripts and perform any Powershell specific commands. Note that in order to run PowerShell scripts you must make sure you have scripting enabled. You should consult with your IT department to see if you are allowed to enable this functionality.
Below is an example I made demonstrating the necessary run command tool configuration. The command will just be “PowerShell” to enable PowerShell mode in cmd.exe. Then your command arguments should be the path where the script is located so it can run:
In this particular case, I want to read into the Designer the results of my script, so I specify the file that is being written as the Read Results. My “helloworld.ps1” script only contains the below:
"Hello World" | Out-File c:\temp\test1.txt
As you can see, this kicks off in the Designer and opens the script output file to continue downstream, successfully implementing Powershell scripting: