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 |
|---|---|
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. | |
Adds new fields to a table, feature class, or raster. | |
Adds global IDs to a list of geodatabase feature classes, tables, and feature datasets. | |
Adds GNSS fields to a feature class in a geodatabase. | |
Adds a database-maintained, incrementing ID field to an existing table or feature class in a Dameng, IBM Db2, Microsoft Azure SQL Database, Microsoft SQL Server, Oracle, or PostgreSQL database. A database-maintained ID field is required for all feature classes or tables you plan to edit through a feature service. | |
This tool allows you to rename fields or field aliases for a geodatabase table or feature class. | |
Creates a default value for a specified field. When a new row is added to the table or feature class, the specified field will be set to this default value. | |
Transforms fields in a table or feature class based on schema defined in the definition table and creates a new table or feature class. | |
|
Calculates the end time of features based on the time values stored in another field. | |
Calculates the values of a field for a feature class, feature layer, or raster. | |
Calculates the values of two or more fields for a feature class, feature layer, or raster. | |
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. | |
Converts time values recorded in a date field from one time zone to another time zone. | |
Deletes one or more fields from a table, feature class, feature layer, or raster dataset. | |
Disables COGO on a line feature class and removes COGO fields and COGO-enabled labeling and symbology. COGO fields can be deleted. | |
Disables editor tracking on a feature class, table, feature dataset, or mosaic dataset. | |
Enables COGO on a line feature class and adds COGO fields and COGO-enabled labeling to a line feature class. COGO fields store dimensions that are used to create line features in relation to each other. | |
Enables editor tracking for a feature class, table, feature dataset, or relationship class in a geodatabase. | |
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. | |
Creates a table of descriptive statistics for one or more input fields in a table or feature class. | |
Migrates date fields in a table to high precision. | |
Reclassifies values in a numerical or text field into classes based on bounds defined manually or using a reclassification method. | |
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. | |
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. | |
|
Switch data stored in fields or columns to rows in a new table or feature class. |