You are here: Tools > All Tools > Auto Field

Auto Field Tool

The Auto Field tool reads through all the records of an input and sets the field type to the smallest possible size relative to the data contained within the column.

The tool will correctly assign a numeric field to a string data type where any record starts with zero and not a number.

Configuration Properties

In Select String Fields to Auto Change Field Type, select the fields to auto configure.

While this tool is easily configured in one step, the workflow must be run at this point for the configured fields to be properly loaded and recognized downstream. Connect the Auto Field tool to a Browse tool and run the workflow before configuring additional downstream tools.