Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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