âShow Table of Contents
The Select tool includes, excludes, and reorders the columns of data that pass through a 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.
These tools include Select tool functionality: Append Fields Tool, Join Tool, Join Multiple Tool, Find Nearest Tool, Spatial Match Tool.
The Select tool Configuration window displays a table with information about incoming data. Each row in the table represents a column in the data. Edit the data table to modify data.
To include a column in data, select the check box to the left of the column name. Deselect the check box to exclude the column.
To reorder the columns of data:
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.
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, click Size and type 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.
To change the name of a column, click Rename and type the new name.
To add a description, click Description and type a description.
After selecting or highlighting rows (columns of data) in the table, click Options to view more configuration options:
Other configuration options:
1776,45 read as a String data type and converted to a Double will output as 1776.45 with this option selected.
1776.45 read as a Double data type and converted to a String will output 1776,45 with this option selected.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.