This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Does anyone know how to input multiple zip files with Input Data Tool?
I am trying to input 2,300 zip fies(all of them have one csv file in it and they are in the same folder) with Input Data Tool, but cannot find the way to select multiple zip files in "Open a data file" window.
I know that we can open mulple csv files using " * ", however it did not work for zip files.
I think you can do this using a directory tool to get a list of all the zip files and then feed it into a dynamic input tool updating the filename as long as the csv files are named the same within the zip.
I have attached a sample showing how it might work. You will need to change the CSV filename in the formula tool if this would work
Otherwise if filenames vary, you could do this by extracting all the files into a temporary folder and importing the results.
I am happy to put a sample together for the second if that is the case
A little late, but if you are still looking for an answer, check out JD's response above. As long as your files all of the same field layout, you can use the workflow he provided and simply change the path on the directory and modify the formula to reflect your files.