Multiple Zip files extraction and Load process using Alteryx

[Sharathkumarv]

Dear All,

We have a requirement  where approximately 200 zip files coming daily that need to be unzipped and loaded into our database. Here are the steps that I followed and  developed the Alteryx workflow but it taking ages to complete the workflow:

1. All the files are located on the SFTP server.
2. Each zip file contains 13 different .csv files, and these 13 file names and formats are same across all 200 zip files.
3. We need to extract the zip files, resulting in a total of 2600 .csv files (200 * 13).
4. After extraction, we need to load all 2600.csv files into the Oracle database.

Could you please let me know do you have any solution to accommodate the above requirement ?. any suggestions are welcome.

[MeganBowers · Accepted solution]

It seems like @MetteTranter solved a problem like this as documented in this success story: https://community.alteryx.com/t5/Alteryx-Success-Stories/NHS-Lothian-Streamlines-Zip-File-Preparatio...