Hello!
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 \\
Any insight would be appreciated
