You are here:

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.

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.

Output

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

FieldName_Tile_Num

A fix was made to this macro between 9.0 and 9.1 that may cause existing workflows to break. The macro now outputs an Int64 field instead of a String field. This was a necessary change as the tool was not sorting records properly due to the fact it was sorting a string instead of a numeric value.