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

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.

Parse

Download

Accepted answers

FinnCharlton

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.

All comments

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703