Gzip File Support

Version:
2019.3
Last modified: September 26, 2019

Alteryx tools used to connect

Use the Input Data Tool to select one or more data files stored within a Gzip (*.gz, *.tgz) file. The following file formats can be read from a .gz, or a .tgz file and extracted to a temporary location on your hard drive:

.cydb, .dbf, .kml, .grc, .grd, .qvx, .sas7bdat, .sav, .sz, .xlsm, .xlsx, .xlsx (legacy), .xls, .xml, .avro, .csv, .json, .yxdb

  • If the files being extracted exceed 2GB, select the Allow Extraction of Files >2GB from the Input Data tool's Configuration window.
  • Designer supports a 15 to 1 compression rate for the Gzip layer. Verify that you have 15 times the compression rate.


    Example:
    If your compressed Gzip file is 1GB, make sure that you have 15GB of space available on your hard drive.

  • Gzip files are not supported in Alteryx Gallery.

 

Gzip files containing a tar file

    Selecting Gzip files containing a tar file

    1. Select the *.tar.gz or *.tgz file to access. See Input Data Tool.

      The Extract File window opens. Designer scans all files within the *.tar.gz/*.gz file and generates a list of discovered formats.

    2. From Select File Type to Extract, select the format for Designer to display in the Files list.

      You can Select Other Files to show a list of all files found within the *.tar.gz/*.gz file, including files with no extension or an unrecognized extension, such as *.txt or *.log.

      • If you choose Select Other Files, you must click Parse Other Files As to select the format to use when parsing the selected files.

    3. Under Select Files, select one or more files to bring in to Designer.
      • You can select multiple files, but Designer can only parse the files in a single format.
      • When you select multiple files, Designer uses the first file to determine the schema (number of fields, data types, etc.). For subsequent files, Designer performs the following validation:
        1. If the number of fields is not equal, the file is skipped and a warning is generated. If equal, the next check is performed.
        2. If the data types are not equal, the file is skipped and a warning is generated. If equal, the next check is performed.
        3. If the field names are not equal, the file will still be read, but a warning is generated.
    4. Click Open.

    Gzip files containing a data file

    Selecting Gzip files containing a data file

    1. Select the *.gz file to access. See Input Data Tool.

      The Extract File window opens.

    2. Select the type of file to parse from the dropdown menu.

      For Excel files you are prompted to select the sheet or range of the file to parse.

    3. Click Open.

     

    Was This Helpful?

    Need something else? Visit the Alteryx Community or contact support.