Output Data Tool

Output Data tool - classic mode

For default mode, see Output Data Tool.

To switch between classic mode and default mode, see User Settings.

Use the Output Data tool to write results of a workflow to supported file types or data sources.

Use other tools to write to other supported data sources. For a complete list of data sources supported in Alteryx, see Supported Data Sources and File Formats.

Configure the tool

  1. In the Configuration window, type a file path in Write to File or Database or select an option in the drop-down:

  2. Select file format options. Options vary based on the file or database to which you connect. See File Format Options.
  3. (Optional) Select Take File/Table Name From Field to write a separate file for each value in a selected field. Click the drop-down and select an option:
  • Append Suffix to File/Table Name: Appends the selected field name to the end of the name of the selected table.

  • Prepend Prefix to File/Table Name: Prepends the selected field name to the beginning of the name of the selected table.

  • Change File/Table Name: Changes the file name to the selected field name.

  • Change Entire File Path: Changes the file name to the name of the selected field. The name must be a complete file path. This option can overwrite an existing file if a file exists in the full path directory.

  1. Click Field Containing File Name or Part of File Name and select a field.

  2. (Optional) Select Keep Field in Output.

For best performance and data integrity, close outputs before you run a workflow.