Extracting .tsv file from a .gz file with the Dynamic Input tool

[jgilligan]

I am trying to get data out of a .tsv.gz file and into Alteryx, but I am having trouble using the Dynamic Input tool. I am able to download these files from the SFTP using the download tool. However, when I use the Dynamic Input tool to bring this downloaded file into Alteryx, there is no option to parse the file as a .tsv. I have tried to parse the file as a .csv and set delimiters to \t as well, but I receive an error. Is there any way to unzip the .gz file separately in Alteryx? If I can unzip the file first, I can bring in the .tsv file alone. I was able to unzip the file manually and the .tsv could be brought into Alteryx with no issues, so it seems to be the .tsv.gz format causing this problem.

[FinnCharlton]

Hi @jgilligan, Alteryx can open files within a GZip, try this configuration of the Dynamic Input tool:

Hope this helps!

[FinnCharlton]

Beware that using the Dynamic Input tool requires all of your files to have the same schema - if they don't, try using a batch macro.

[jgilligan]

When I try this, I get a "No file specified in zip archive:" error. Inside of the Dynamic Input tool, I choose the downloaded file as the Input, the location of that downloaded file as the "Read a list of Data Sources" field, and "Change Entire File Path" as the action. Am I setting this up incorrectly?

[FinnCharlton · Accepted solution]

You need to create a file path that includes both the full path of the .gz folder, and the file name of the file inside that you want to import. Do this with a formula tool, with a formula like this:

[FullPath] + "|||" + [NameOfFileWithinZip.tsv]

This will give you a File Path that looks like this:

Change the entire File Path in your dynamic input tool to this and see if it works.