Select tool icon

Select Tool

Last modified: September 15, 2021

Docs are available before the release of Designer Cloud so you can get a sneak peek. This content might change between now and the official release.

One Tool Example

Select has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer Cloud.

Use Select 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, Join tool, and Join Multiple tool.

Configure the Tool

Use the table in the configuration window to modify the incoming data stream. Each row in the table represents a column in the data. Column identifies the name of each column in the data and auto-sizes to fit column names without cutting off any text.

Select, Deselect, Sort, and Reorder Columns

  • To include a column in data, check the checkbox next to the column name. Uncheck the checkbox to exclude the column.
  • To sort the columns of data based on the column name...
    • Click on the column name to sort in ascending order.
    • Click on the column name a second time to sort in descending order.

Sort Method

Depending on the language of your Designer Cloud instance, a different default sort order might be used. Consult the Localization User Settings to read more about the default Sort Method.

  •  To reorder the columns of data...
    • Use the Move Up or Move Down arrows.
    • Select and hold the reorder icon and drag the column up or down.

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 types and can be edited for fixed decimal numeric types and all string types.

Use the [data type]: Forced option to ensure a column always contains the expected data type.

 Rename a Column or Add a Description

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

Commas as Decimal Separators 

Check the Use Commas as Decimal Separators (String/Numeric Conversions only) to use a comma (,) as a decimal separator.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.