Essential analytic concepts

Real-time analysisBig data analysisAnalytic optionsShare analyticsView analytic details and statusGeofence analysisSample real-time data

Analyze patterns

Calculate DensityCalculate JourneysFind Hot SpotsFind Point ClustersGeneralized Linear RegressionForest-based Classification and Regression

Enrich data

Calculate Motion Statistics

Find locations

Delay and Reorder TracksDetect IncidentsDetect GapsFind Dwell LocationsFind Similar Locations

Manage data

Add XYZ ValuesCalculate FieldControl Event VolumeDissolve BoundariesFeature to PointFilter by ExpressionFilter by Time RangeFilter by GeometryMap FieldsMergeMulti-MergeOverlay LayersProjectRoute by ExpressionsSelect FieldsSplit by Attributes

Summarize data

Aggregate PointsJoin FeaturesReconstruct TracksSummarize Attributes (Big data)Summarize Within

Use proximity

Create BuffersCreate Range FansCalculate DistanceSnap to Network

Schedule recurring analysis

Schedule recurring big data analysisNear real-time analysisGenerate up-to-date informational products

Arcade expressions

Use Arcade expressionsUse track functionsBest practices for Arcade expressions

Troubleshoot

Common analysis issues and solutions
Back to Top

Split by Attributes

In this topic

  1. Examples
  2. Usage notes
  3. How the tool works
  4. Parameters
  5. Output layer

Available in real-time and big data analytics.

The Split by Attributes tool receives an input table, identifies a string field and delimiter, and produces an output table in which the rows are split by that field’s delimiter.

Examples

Incoming data is not always structured for immediate analysis. Some data providers send multiple values in a single field, such as a list of units, lanes, circuits, or zones. The Split by Attributes tool creates a separate record for each value in the selected field, allowing each value to be analyzed, routed, or summarized individually.

The following are example use cases for the tool:

  • An emergency dispatch feed includes responding units in a single field, such as E12,L3,M5. The tool can split the field to create one record per unit for tracking response workload.
  • A utility outage alert includes affected circuits in a single field, such as CIR-104;CIR-991;CIR-120. The tool can split the field to create one record per circuit for routing or assignment to circuit owners.
  • A weather or hazard notification includes affected zones in a single field, such as ZoneA/ZoneB/ZoneC. The tool can split the field to create one record per zone for zone-based alerting or analysis.

Usage notes

Note the following when working with the tool:

  • This tool only accepts string fields.
  • The delimiter field allows only one character.
    • Example characters include , : ; / and |. A single space is supported. \t can also be used to represent tab characters.
    • The characters \ “ ‘ and ` are not supported.
  • Leading and trailing spaces can be removed with the Calculate Field tool using the Trim() function in ArcGIS Arcade.
  • If an incoming field is null or empty, the tool returns a single record with a null value.

How the tool works

Given the input table below with , as the specified delimiter, with the following fields:

The input table contains inspection date, vessel type, and a field with multiple comma-separated water locations.
The input table includes a Last_Waters_Visited field containing comma-separated values.

The Split by Attributes tool provides the following output:

The output table shows each comma-separated value in its own row while other fields repeat.
In the output table, the tool creates a row for each separated value.

If delimiters occur sequentially, the tool returns rows for each occurrence between delimiters with an empty string for the field. For example, the following input uses , as the specified delimiter:

The input table contains home city, name, and a color field with multiple values separated by commas, including sequential delimiters.
The input table includes the Favorite_Color field containing sequential comma-separated values.

This input results in the following output:

The output table shows values split into rows, including an empty entry generated from sequential delimiters.
In the output table, the tool splits values into multiple rows and includes an empty row for sequential delimiters.

Parameters

The following are the parameters for the tool:

ParameterExplanationData type
Input layer

The real-time features to be split.

Features

Field name

The field that contains the delimited string to process.

Only string fields are available to choose from. If no string fields are available in the Input layer parameter, a validation error occurs.

String

Delimiter

The character used to split the string field into multiple values.

String

Output layer

The output layer usually contains more rows than the input layer because the tool splits rows based on the selected field and delimiter. Rows with multiple delimited values create one output row for each split value, and rows without the delimiter create one output row.

All input fields and geometry are preserved. Each child row retains the same attributes and geometry from the parent row except the selected field that only contains one split value per row.

Feedback on this topic?

In this topic
  1. Examples
  2. Usage notes
  3. How the tool works
  4. Parameters
  5. Output layer