As a batch, to input individual csv files located in multiple zip folders

healsio2025

10 zip folders, 1 csv file in each folder, with similar naming convention, for example

2010bank_rec.zip

2010bank_rec.csv

2011bank_rec.zip

2011bank_rec.csv

2012bank_rec.zip

2012bank_rec.csv

etc

How could I import the 10 zip folders as a batch?

I was told to use dynamic input tool, but I keep getting this warning:

Custom Tools

Accepted answers

Yoshiro_Fujimori

@healsio2025

When you read .csv file in .zip file, you need to pass the full path to Input Data Tool like below:
C:\Users\yoshi\Downloads\zip\FileName.zip|||FileName.csv

You can use Dynamic Input Tool in the same manner, passing the list of full path of .csv file in the above format.

If there is only one .csv file in a .zip file with the file name same as the .zip file,

you can create the list with Directory Tool and Formula Tool as the attached sample workflow.

If you have multiple files in a .zip file, you may need to creat a batch macro.

I hope this helps. Good luck.

Workflow

Formula Tool
[FullPath] = [FullPath] + "|||" + Replace([FileName], ".zip", ".csv")

dynamicInputZip.zip

All comments

Yoshiro_Fujimori

@healsio2025

When you read .csv file in .zip file, you need to pass the full path to Input Data Tool like below:
C:\Users\yoshi\Downloads\zip\FileName.zip|||FileName.csv

You can use Dynamic Input Tool in the same manner, passing the list of full path of .csv file in the above format.

If there is only one .csv file in a .zip file with the file name same as the .zip file,

you can create the list with Directory Tool and Formula Tool as the attached sample workflow.

If you have multiple files in a .zip file, you may need to creat a batch macro.

I hope this helps. Good luck.

Workflow

Formula Tool
[FullPath] = [FullPath] + "|||" + Replace([FileName], ".zip", ".csv")

dynamicInputZip.zip

healsio2025

Thanks, what would "|||" mean in this context?

jrlindem

"|||" is just "triple-pipes" (keyboard key above the right-side enter key on your keyboard). Nothing more than the way Alteryx chose to code the input syntax for Excel Sheets or embedded pathways within files.

Example (Excel): filename.xlsx|||sheet1

Example (.zip): zip_filename.zip|||filename.csv

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703