Importing multiple csv files from zip subfolders

Question

Hi -

I am trying to import csv files from subfolders within multiple zip files as follows:

\Input Folder\file1.zip\subfolder\ABC.csv

\Input Folder\file2.zip\subfolder\ABC.csv

\Input Folder\file3.zip\subfolder\ABC.csv

The csv files always have the same file name and structure.  I have seen similar threads on this but haven't come across a scenario where the csv files are contained within a subfolder of the zip files.  I am restricted from running batch commands.

Any suggestions would be greatly appreciated.  Thanks!

seinchyiwoo · Answer

Hi,

Input tool allows you to connect to zip file directly.

Attach is an example of using batch macro (highlighted) to batch connect to all zip files then combine the data using Dynamic Input tool.

Mine is a simple csv with just 1 row and 1 column, and I duplicated the same csv twice. After the workflow is executed, there are in total of 2 rows in the result.

You can right click the batch macro (yxmc attached) to look at the underlying workflow and logic:

Is this close to what you're looking for?

Best,

Seinchyi

Connect to a bunch of zip file and append all data.yxzp

Connect zip file batch macro.yxmc

Connect to a bunch of zip file and append all data.yxmd