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.
I am attempting to create an Alteryx workflow that ingests data, transforms it, then parses it out as zip folders along with a set of copied files per folder created (dynamically).
Currently (using a combination of the run command, bat files, and the output tool) am able to create these folders dynamically, parse the rows as individual files, then zip them. However, I am running into an issue getting the powershell portion to work. After the folders are created but before they are zipped, I wrote a Powershell script that simply finds each child folder in the output directory and copies 6 files to each existing folder. Here is a quick snap of how it fits in my workflow:
Some context: copyFilestoEach.ps1 is the script that actually performs the copy/move operations. psExecute.ps1 is just a dummy script file that I write a text string to because the run command required me to have an output connection and I didn't wish to modify the actual script.
I keep receiving this error 5, access is denied. I looked through quite a few forum posts but didn't seem to find one pertaining spe I tried changing from a non-admin to Admin (in elevated session) with no luck. Any idea what could be causing this and is there a resolution? I am banging my head trying to figure this out. I am using explicit pathing as practice for when I publish to the server and replace C:\ with \\
Here is an older thread about running powershell from Alteryx. This was written by the great and powerful @Ozzie whom we are fortunate to still have around. The part that stands out to me is at the beginning where it says you need to have "scripting enabled". If that doesn't work, maybe we can wrangle Ozymandias in and figure it out.