Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Mass Read Records in Folder Filled with Zip Files

kristinaheuer
7 - Meteor

 

I am trying to perform data validations on delta files that have been loaded to an FTP server. I downloaded the list of files which are zip files - each zip file contains one csv file. All csv files follow an identical format structure.

 

I would like to be able to mass read in this directory so that I can read in all records from all files into one master table. The wildcard option within the Input tool does not help me since the csv files are all within these zip files. Options?

 

kristinaheuer_0-1635417635303.png

 

1 REPLY 1
Jason_
8 - Asteroid

This issue sounds similar to yours and seems to have been solved. Have you tried this yet?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Read-CSV-Files-from-multiple-zips/td-p...

Labels