Macro for zip files with different file names

Question

Hi

Is there an easy way of processing files with the same schema but with different zip files?  I can create a macro when the file name is the same, but the file name changes depending upon when it is created which causes me problems.

It's csv files for completeness.

Thanks

ck2024 · Answer

Hi @Prometheus - that is a very good suggestion and one that I hadn't even thought of - I think you're right that it'll work easily enough, just hadn't considered doing it from within a zip file - will report back either way. Thank you

Prometheus · Answer

@ck2024 Have you tried using the wildcard character *? So for File_1.csv, File_2.csv, and File_3.csv, you can put File_*.csv into an Input Data or Dynamic Input tool and it'll bring every CSV file that starts with "File_" in and open it, just as long as the schema matches.