An overview of the Fields toolset

The Fields toolset contains tools to create and modify fields. A field is a column in a table; each field contains the values for a single attribute. Any number of fields can be included in a table. Settings can be specified for fields, such as the field type and the maximum size of the data that can be stored in it.

Tool	Description
Add Field	Adds a new field to a table or the table of a feature class or feature layer, as well as to rasters with attribute tables.
Add Fields (multiple)	Adds new fields to a table, feature class, or raster.
Alter Field	This tool allows you to rename fields or field aliases for any geodatabase table or feature class.
Calculate End Time	Calculates the end time of features based on the time values stored in another field.
Calculate Field	Calculates the values of a field for a feature class, feature layer, or raster.
Calculate Fields (multiple)	Calculates the values of two or more fields for a feature class, feature layer, or raster.
Convert Time Field	Transfers date and time values stored in a field to another field. The tool can be used to convert between different field types (text, numeric, or date fields) or to convert the values to a different format such as dd/MM/yy HH:mm:ss to yyyy-MM-dd.
Convert Time Zone	Converts time values recorded in a date field from one time zone to another time zone.
Delete Field	Deletes one or more fields from a table, feature class, feature layer, or raster dataset.
Disable Editor Tracking	Disables editor tracking on a feature class, table, feature dataset, or mosaic dataset.
Enable Editor Tracking	Enables editor tracking for a feature class, table, feature dataset, or relationship class in a geodatabase.
Encode Field	Converts categorical values (string, integer, or date) into multiple numerical fields, each representing a category. The encoded numerical fields can be used in most data science and statistical workflows including regression models.
Reclassify Field	Reclassifies values in a numerical or text field into classes based on bounds defined manually or using a reclassification method.
Standardize Field	Standardizes values in fields by converting them to values that follow a specified scale. Standardization methods include z-score, minimum-maximum, absolute maximum, and robust standardization.
Transform Field	Transforms continuous values in one or more fields by applying mathematical functions to each value and changing the shape of the distribution. The transformation methods in the tool include log, square root, Box-Cox, multiplicative inverse, square, exponential, and inverse Box-Cox.
Transpose Fields	Switch data stored in fields or columns to rows in a new table or feature class.