Split By Attributes (Analysis)


Splits an input dataset by unique attributes.


  • The Input Table can be a feature class or table.

  • A feature class or table will be created for every unique combination of attributes from the Split Fields parameter.


SplitByAttributes(Input_Table, Target_Workspace, Split_Fields)
ParameterExplanationData Type

The input feature class or table whose data will be split into the target workspace.

Table View

The existing workspace where the output feature classes or tables are written.

Workspace; Feature Dataset

The fields on which the input will be split into new feature classes or tables.


Derived Output

NameExplanationData Type

The workspace containing the features classes or tables created by splitting the input.

Workspace; Feature Dataset

Code sample

SplitByAttributes example 1 (Python window)

The following Python window script demonstrates how to use the SplitByAttributes tool in immediate mode.

import arcpy
arcpy.env.workspace = 'c:/data/base.gdb'
arcpy.SplitByAttributes_analysis('ecology', arcpy.env.scratchGDB, ['REGION', 'ECO_CODE'])
SplitByAttributes example 2 (stand-alone script)

The following script demonstrates how to use the SplitByAttributes tool.

# Description: Use the SplitByAttributes tool to split a feature class by unique values.

# Import required modules
import arcpy

# Set local variables
in_feature_class = 'c:/data/base.gdb/ecology'
target_workspace = 'c:/data/output.gdb'
fields = ['REGION', 'ECO_CODE']

arcpy.SplitByAttributes_analysis(in_feature_class, target_workspace, fields)

Licensing information

  • Basic: Yes
  • Standard: Yes
  • Advanced: Yes

Related topics