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.

ToolDescription

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 a 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 Temporal Field

Transfers temporal values stored in a field to another field. The tool can be used to convert between field types (text, numeric, or datetime 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.