File Format Options

This option is not supported by all DBF readers.

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.

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.

If not selected, only the value key is displayed.

Quotes: Ignore delimiters in quotes.

Single Quotes: Ignore delimiters in single quotes.

Auto: Ignore auto-detected delimiters.

None: Do not ignore delimiters.

Use this option only when writing large temporary files that will not be used in spatial operations. This option writes smaller files and faster.

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

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

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.

Auto: inserts quotes around fields that have a single or double quote, and around fields that contain delimeters

Always: inserts quotes around each field

Never: does not insert quotes

Deselect the check box to run preSQL statements when the workflow is executed instead.

Alteryx does not support reading or writing multiple geometry types in a single file.

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.

The table stores represent how the data is stored. The system default honors the table store of the underlying database.

You will notice a decline in performance when you create a column store table versus a row store table.

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

By default, transaction size is 10000, 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.