Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Input multiple tsv.gz files with different names from one directory.

6 - Meteoroid

Has anyone found a mechanism for inputting multiple tsv.gz files from one directory?  The files have different names, but share a common prefix.

Wild card does not appear to work with .tsv.gz.
Using a Directory tool with a dynamic input also does not appear to work as there is no mechanism for selecting the parse type for each subsequent file.

6 - Meteoroid

I was able to successfully complete this task by first leveraging the macro tool found on this post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Directory-output-many-gz-to-many-excel...

After that it was a matter off appending a suffix to the file path based on what was visible in the macro after selecting the parse file type.