Explore fields

You can use the fields panel in a Data Engineering view to work with the fields in layers and tables. The fields panel lists the layer or table fields, including their properties and options, to explore each field using symbology, charts, and the attribute table.

Learn how to open a Data Engineering view

Display a list of fields

After you open the Data Engineering view, the fields panel displays field aliases of all the visible fields of the selected layer. Each field listing includes an icon corresponding to the data type for each field. Hover over a field to see the field name, field alias, and field type.

Fields panel

The data type icon indicates when a field is sourced from a joined table Join.

You can specify which data types are displayed by applying filters using the filter button Rules at the top of the panel.

You can search for specific fields by providing text in the Search Fields text box Search Fields.

A count showing the number of fields in the layer is displayed at the bottom of the fields panel. When a filter or search is applied, the number of fields matching the filter or search is also shown.

To change the displayed field aliases to field names, click the Filter button Filter and change the Display Field by option to None.

Note:

You can also drag fields from the fields panel to any geoprocessing tool that accepts fields as input.

Update symbology based on fields

You can visualize the fields of a feature layer in a map using the Data Engineering view. By displaying fields on a map, you can explore where features are located, how values are distributed in space, and whether any places are missing data.

In the fields panel, when the field can be symbolized, you can update the map symbology using the Update Symbology option Update Symbology.

To update symbology based on fields, complete the following steps:

  1. In the fields list, hover over a field and click Update Symbology Update Symbology to update the symbology for that field.

    The default symbolization method is based on the data type of the selected field.

    Field data typeDefault symbology

    Numeric (short, long, big integer, float, double)

    Graduated colors—Show quantitative differences in feature values with a range of colors. The default classification method is Natural breaks (Jenks) with four classes.

    Text or date

    Unique values—Apply a different symbol to each category of features in the layer based on one or more fields. Only the first 100 unique values are given a unique symbol; all other values are grouped together.

  2. To further configure the symbol properties, right-click the field in the fields panel and click the Symbology button Symbology or click the Symbology button on the Map ribbon.

    The symbology pane appears with the method and field name populated by default.

  3. To revert to the original symbology, use the undo action on the Quick Access Toolbar.

Create charts based on fields

You can visualize and explore the data using charts, which help reveal patterns, trends, relationships, and structure in the data. Use charts together with maps to tell a story from the data. In the fields panel, when a chart can be made using the field, you can create charts for a single field using the Create Chart option Create Chart or for multiple fields using the Create Chart menu.

To create a chart based on fields, complete the following steps:

  1. In the fields list, hover over a field and click Create Chart Create Chart to create a chart for that field.

    A default chart is created based on the data type of the selected field. The chart's properties pane also appears, allowing you to further configure the chart's appearance.

    Field data typeDefault chart type

    Numeric (short, long, big integer, float, double)

    Histogram—Visualize the distribution of values in a numeric variable by grouping numbers into bins and measuring the frequency of those groups.

    Text

    Bar chart—Summarize and compare categorical data. Any null values will receive their own bar in the bar chart.

    Date (date, date only, timestamp offset)

    Line chart—Visualize change over a continuous time range.

    Learn about the types of tabular charts

  2. Optionally, right-click the selected field and click Create Chart to learn about other chart types that are available for the field.

    A list of available charts are displayed in the menu.

  3. Optionally, select multiple fields in the panel to create charts.

    For example, select two fields, right-click, and click Create Chart to create a scatter plot, a scatter plot matrix, or a box plot.

Review field attributes

You can learn more about each field's attributes by opening the attribute table and reviewing the values. When there are hundreds of fields in an attribute table, finding fields of interest may be difficult. The fields list in the Data Engineering view allows you to find the field of interest in the attribute table.

To review fields attributes in the attribute table, complete the following steps:

  1. In the fields list, hover over a field and click the Go to Attribute Table button Field to open the attribute table at the location of that field.

    The field name is set as the active field.

  2. Optionally, right-click the selected field and choose Attribute Table.
  3. Optionally, select multiple fields in the panel, right-click any field, and choose Attribute Table to open the attribute table at the location of the first selected field.

    All of the selected fields are set as active fields.

Similarly, you can explore the design of the fields using the fields view. To find and set the fields in the fields view, select the fields, right-click the selection, and choose Fields.

Access the Data Engineering tools

Several geoprocessing tools are grouped into the following categories for data engineering: Clean, Construct, Integrate, and Format. You can access these categories and their tools from the Data Engineering ribbon. To access the tools applicable to a field’s data type, select a field in the fields panel and right-click.

Note:

Most geoprocessing operations that modify the input data cannot be undone.

Learn more about data engineering tools for preparing data