Auto Field Tool
Auto Field Tool
One Tool Example
Auto Field has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.
Use Auto Field to read through all of the records of an input and set the field type to the smallest possible size relative to the data contained within the column.
The tool correctly assigns a numeric field to a string data type where any record starts with zero and not a number.
Configure the Tool
In Select String Fields to Auto Change Field Type, select the fields (columns) to autoconfigure. Select fields individually, or use All or Clear.
While you can configure this tool in one step, you must run the workflow at this point for the configured fields to be properly loaded and recognized downstream. Run the workflow before you configure additional downstream tools.