Alteryx Designer Desktop Discussions

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

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

TeeOffData
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.


1 REPLY 1
TeeOffData
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.

 

 

Labels
Top Solution Authors