Inputting multiple zip files containing csv files

[Govind_Dileep_G]

Hi,

Can anyone share any idea on how to input multiple zip files containing .csv files all at once?

Thanks in advance.

[JosephSerpis]

Hi @Govind_Dileep_G I find the third option e.g. the Batch Macro approach works with files in a zip folders from this article.

[Govind_Dileep_G]

Thankyou @JosephSerpis . Let me have a look in to this

[danilang]

Hi @Govind_Dileep_G 

The solution from @JosephSerpis will work well if you know, or can determine though a formula, the names of the csv files in the zip file.  If not you'll need to apply some python magic.  The Zip Files Metadata Extractor and Reader workflow uses a python based macro to first find the names and relative paths of the files within the zip archive.  These are then passed to a macro which does the actual reading of the files. 

Dan.