Blue circle with a white dot, a checkmark and another dot in a line.

Select Tool

Version:
Current
Last modified: May 27, 2020

Use the Select tool to include, exclude, and reorder the columns of data that pass through your workflow. Excluding columns can limit the data passing through a workflow and improve performance. You can also use the Select tool to modify the type and size of data, rename a column, or add a description.

Other tools include the Select tool functionality, including Append Fields tool, Find Nearest tool, Join tool, Join Multiple tool, Select In-DB tool, and Spatial Match tool.

Configure the Tool

Use the table to modify the incoming data stream. Each row in the table represents a column in the data.

Select, Deselect, and Reorder Columns

To include a column in data, select the checkbox to the left of the column name. Deselect the checkbox to exclude the column.

To reorder the columns of data...

  1. Select to highlight a row, or select and drag to highlight multiple rows.
  2. Use the Move Up or Move Down arrows, or right-click and drag, to move the rows to a new location.

The Unknown column is selected by default. It allows new columns in the data. Move the column to the location where you want a new column to be.

Modify Data Type and Size

To change the supported length (characters for string and numeric fixed decimal types) or measurement (bytes for other numeric types) of data in a column, select Size and enter a number. Size varies by data type and can be edited for fixed decimal numeric types and all string types. See Data Types.

Use the [data type]: Forced option to ensure a column always contains the expected data type. This is helpful when creating macros. See Macros.

Rename a Column or Add a Description

  • To change the name of a column, select Rename and enter the new name.
  • To add a description, select Description and enter a description.

View More Options

After you select or highlight rows (columns of data) in the table, select Options to view more configuration options:

  • Save/Load: Save Field Configuration as a .yxft file. The Alteryx Field Type File is a text file that can be used in other workflows using the Load Field Names or Load File Names and Types options.
  • Select: Select or deselect all or highlight columns. Options include Select All and Deselect All.
  • Change Field Type of Highlighted Fields: Change the data type of all highlighted columns at once.
  • Sort: Sort the column order in ascending or descending order. Options include Sort on Original Field Name, Sort on New Field Name, and Sort on Field Type, or Revert to Incoming Field Order.
  • Move: Move highlighted columns to the top or bottom of the list.
  • Add Prefix to Field Names: Add a prefix to the selected or highlighted column name.
  • Add Suffix to Field Names: Add a suffix to the selected or highlighted column name.
  • Remove Prefix or Suffix: Remove the prefix or suffix from the selected or highlighted column name.
  • Clear All Renames: Remove the new name for all column.
  • Clear Highlighted Renames: Remove the new name for all highlighted columns.
  • Revert All to Original Type & Size: Undo all changes to type and size in all columns and use the original values.
  • Revert Highlighted to Original Type & Size: Undo changes to type and size in the selected or highlighted columns and use the original values.
  • Forget All Missing Fields: Remove all columns that are no longer included in the data.
  • Forget Highlighted Missing Fields: Remove all highlighted columns that are no longer included in the data.
  • Deselect Duplicate Fields: Deselect the second column when duplicate column names exist; this optional is only available with multiple inputs.
  • Use commas as decimal separators: For string and numeric data type conversions only, select this option to use commas as decimal separators instead of periods.

Examples

  • 1776,45 read as a String data type and converted to a Double outputs 1776.45 with this option selected.
  • 1776.45 read as a Double data type and converted to a String outputs 1776,45 with this option selected.
Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.