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 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.
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
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |