Select to allow Alteryx to extract a file greater than 2 GB. See Zip File Support.
Select to read an open file that may be in the process of being updated. This option is intended for reading web logs.
Select to append records to an existing table.
Select to append fields and set how output fields will map to the fields in the OleDB table.
Select to store a .yxdb file on disk so that data sources are not contacted repeatedly as you create a workflow.
This option is only used when workflows are run in Alteryx Designer; it does not apply workflows run as scheduled, in Gallery, or via the command line.
Select a code page for converting text in input or output data. See Code Pages.
Select to create all Int32 fields as 32 bit (4 byte) binary values in the database instead of the default 11 character text format.
This option is not supported by all DBF readers.
Select the field delimiter in the data.
Use \0 to read or write a text file with no delimiter. Use 0 if the data contains two or more delimiters to force Designer to read the data as flat text.
Use the RegEx Tool in Tokenize mode to parse your data.
Define the file name of a .flat file used as a layout file.
Select to disable a status report of file read-in progress; this speeds up read time.
Select to output a compressed .avro file.
The deflate algorithm (similar to gzip) is used and should be supported by other Avro-capable tools such as Hive. Compression increases output time, but with larger files, will reduce network time.
Read and apply value labels (key) to data. This option is selected by default for SPSS and SAS files. See StatTransfer Supported File Formats.
If not selected, only the value key is displayed.
Define the maximum field length in the input data.
Select the data file format.
Change the file (or files) to input. See Zip File Support.
Select if the first row should be treated as data, not a header.
Select if the first row should be treated as a header.
Select to allow character columns to be treated as SQL_WCHAR, SQL_WVARCHAR, or SQL_WLONGVARCHAR.
Use the selected .flat file (default), or override the setting.
Use the selected .flat file (default), or override the setting.
Select an option:
Quotes: Ignore delimiters in quotes.
Single Quotes: Ignore delimiters in single quotes.
Auto: Ignore auto-detected delimiters.
None: Do not ignore delimiters.
Define the character or sequence of characters signifying the end of a line of text.
Define the number of records to output to a single file. If the data contains more records, multiple files are created and named sequentially.
Select to turn off the spatial index.
Use this option only when writing large temporary files that will not be used in spatial operations. This option writes smaller files and faster.
Select to convert incoming fields to string data type; this bypasses conversion errors if the data type is wrong in .dbf files.
Select to append a field with the file name or file path to each record.
Select an output option:
Create New Sheet: creates a new sheet, but does not overwrite an existing sheet
Append to Existing Sheet: appends data to an existing sheet so that the output consists of new and previous data
Overwrite Sheet (Drop): deletes the selected sheet and writes data into a new sheet with the selected name
Overwrite File (Remove): deletes the existing file and creates a new file
Select an output option:
Create New Table: creates a new table, but does not overwrite an existing table
Append Existing: appends data to an existing table so that the output consists of Records Before plus Records After
Delete Data and Append: deletes all original records from the table and appends data to the existing table
Overwrite Table (Drop): drops the existing table and creates a new table
Select an option:
Update, warn on failure updates existing records using the output and warns if a record could not be updated
Update, error on failure: updates existing records using the output and stops processing if a record could not be updated
Update, insert if new: updates existing records using the output and inserts new records if they were not in the database table and stops processing if a record could not be updated
If there are multiple records with the same primary key and no other SQL errors occur, the new record updates the older record in the database. Use the Unique Tool to check for multiple primary keys prior to writing to the database.
Selected by default, this option overwrite an existing file type of the same name.
Change the format in which to parse the file.
Select to parse output data as a string; if not selected, data is parsed based on data type.
Select how a password will display in the Configuration window: Hide (default), Encrypt for Machine, Encrypt for User.
Define an SQL statement to execute via the ODBC/OLEDB driver before the output table is created.
Define an SQL statement to execute via the ODBC/OLEDB driver after the output table is created.
Define the output project. By default, Projection is blank and outputs to WGS 84. See Projection Support.
Choose an option for quoting output fields:
Auto: inserts quotes around fields that have a single or double quote
Always: inserts quotes around each field
Never: does not insert quotes
For data with polygon objects, select to use the polygon's centroid as the spatial object.
Select to limit the records read from input data. If 0, all records are returned.
Selected by default, this option includes source and description data in the metainfo. Deselect the option to exclude source and description data.
Use to bring in multiple inputs if data files are in a sub-directory and contain the same structure, field names, length, and data types.
Define the spatial object to include in the output. Spatial files can only contain one spatial object per record.
Alteryx does not support reading or writing multiple geometry types in a single file.
Select to display, in the Results window, a message for each transaction. Each message reports the sum of records written up to that transaction.
Define a line number on which to start reading data. By default, it begins on Line 1.
Select to output an .avro file with Null values.
This output option unions fields with a null branch and a value branch. If the Alteryx value is Null, the output will use the null branch; otherwise, the value branch is used.
If this option is not selected, all output fields will write as their native .avro types (non-union). Alteryx fields that are Null are written as their default value.
Use the Formula Tool to handle Null values with 'known' values so that the values can be read in Hadoop.
Select an option to write a separate file for each value of a particular field:
Append Suffix to File/Table Name: appends selected field name to the end of the table name
Prepend Prefix to File/Table Name: prepends selected field name to beginning of the table name
Change File Name: changes the file name to the select field name
Change Entire File Path: changes the file name to the selected field name that contains a full path
Select Quoted or None. Quoted uses the Quote Identifier for the database type.
If data contains multiple tables, define the table to input, or click 
to create a query. See Choose Table or Specify Query Window.
Define the number of records at a time to write to a database.
By default, transaction size is 0, meaning all records. Set records to at least 1000 because the database creates a temporary log file for each transaction which could quickly fill up temporary space.
Select to input data with records that do not conform to the data structure. Typically errors cause the input to fail; this option prevents input failure by treating errors as warnings.
Use the selected .flat file (default), or override the setting.
Use the selected .flat file (default), or override the setting.