Having what seems like a hard time with what seems like a simple issue – combining multiple text files of the same structure into a single file (no headers).
The twist is these are GZIP csv files (csv.gz) which is leading to issues. I’ve tried the two main approaches from the community but not having luck with either one. Below are the details of the two approaches thus far. I can also combine individual file inputs with a union, but this approach is not scalable.
Simpler is better and I would prefer to do without macros or coding, but any assistance is appreciated.
Input Data tool with wildcard*
Input tool works fine with a single gzip file, but inserting a wildcard in the filename to pull all files from a single folder is not working. I assume this is due to the gz filetype somehow but don’t know if there is a workaround. For a single file it’s easy to select CSV filetype from the ‘file in archive’ but with a wildcard in the filename this setting will not 'stick', for lack of a better term
Directory + Dynamic Input tool
This method works to bring data in but it appears to be duplicating the ‘input data source template’, which is worse. Hopefully this is can be solved with a different configuration of the settings.
Workflow is attached but not able to upload source data due to size.