Multi-Field Binning Tool

This macro replicates some of the functionality of the Tile Tool, but has the added feature of being able to tile, or bin on multiple fields at the same time. This tool was built primarily for the predictive tool set and as such will only accept numeric fields for binning. The fields are sorted ascending by default, and the user has the option to tile based on 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.

Configure the tool

Select the fields for binning (only numeric fields are shown): Use the checkboxes to select the numeric fields for binning.
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.

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