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:
The Extract File window opens. Designer scans all files within the *.tar.gz/*.gz file and generates a list of discovered formats.
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.
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:
If the number of fields is not equal, the file is skipped and a warning is generated. If equal, the next check is performed.
If the data types are not equal, the file is skipped and a warning is generated. If equal, the next check is performed.
If the field names are not equal, the file will still be read, but a warning is generated.