âShow Table of Contents
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.
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.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.