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

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:

[Yoshiro_Fujimori · Accepted solution]

@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")

[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