Passing Multiple Values into Zip File Input Tool

BradFolger

I did a quick search but couldn't find anything on this; pardon if it's a duplicate.

I'm trying to dynamically feed values into an Input tool. I've done this with a batch macro when looping through several files in a directory, but that's only been for .xls or .csv files, where the connection string is relatively simple. In my current case, I need to pass in the name of .zip files -- which is easy enough at the top level (filename, full path), but for .zips, an additional attribute is required on the input side -- namely, the name of the file to be extracted from within the .zip that will serve as the basis for the input.

Is there a way to pass both the full path for the filename to the macro, but also the file within the .zip that needs to be extracted from the .zip and serve as the basis for the input? From what I can see, only a single value can be "updated" on a single Input tool using an Action in the Macro -- but I'm assuming there's a way to do this?

Dynamomo

@BradFolger

It works pretty much the same way as your other batch macro except that when you feed in the filename, it will need to look like this:

C:\temp\file3.zip|||file3.csv

The zipfile is listed and then some pipes are added to delimit the file within it.

If you want to see this for yourself, just bring in a zipfile with a file in it using the regular Input Data tool.  Then add a control parameter and an action tool above this.  Now click on the action tool and select Update Value (Default) as the action type.  When you do this, the file - value will be visible and you can see for yourself how the path looks when Alteryx reads it in.

Hope this makes sense.  If not, I can send a macro and workflow but wanted to step you through it so you could see for yourself.