Multi-Field Binning Tool

This Multi-Field Binning Tool replicates some of the functionality of the Tile Tool- additional features allow the data to be binned on multiple fields. Built primarily for the predictive tool set, the Multi-Field Binning tool only accepts numeric fields for binning. By default, fields are sorted in ascending order and can be binned on either equal records or equal intervals.

Version warning

If a workflow made before version 9.1 of uses this tool, the workflow may break when used in later versions because this tool now outputs an Int64 column instead of a String to improve the sorting behavior. There are multiple versions of the Multi-Field Binning tool. To use a previous version of the tool, right-click on the tool and select the version from the Choose Tool Version option.

Configure the tool

  1. Select the fields for binning (only numeric fields are shown): Use the checkboxes to select the numeric fields for binning.
  2. Choose which tile method is used for binning. Choices are:
    • Equal Records: Input records are divided into the specified amount of tiles so that each tile is assigned the same amount of records. This is based solely on the record's position in the input file.
    • Equal Intervals: The minimum and maximum values of the tile field are determined. The range is split into equal sized sub-ranges and records are assigned to tiles based on these ranges.
  3. Use Number of Tiles (max of 1,000) to specify how many bins to create.

View the output

Output includes all fields that went into the tool and a new field for each field selected for binning.

FieldName_Tile_Num