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 your compressed Gzip file is 1GB, make sure that you have 15GB of space available on your hard drive.
The Extract File window opens. Designer scans all files within the *.tar.gz/*.gz file and generates a list of discovered formats.
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.
The Extract File window opens.
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.
Need something else? Visit the Alteryx Community or contact support.