Multi-Field Binning Tool Icon

Multi-Field Binning Tool

Version:
Current
Last modified: October 21, 2019

The 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 Multi-Field Binning tool on your canvas. Choose the field(s) for binning under the Tile Options tab in the Configuration panel, on the left-hand side of the canvas.
    1. Use the checkboxes to select from the numeric fields (only numeric fields are shown).

       If too many records have the same group value, a tile will be skipped.

       

    2. Choose which tile method you are going to use for binning. The options are:
      1. Equal Records: Input records are divided into the specified number of bins. Each bin is assigned the same number of records. This is based solely on the record's position in the input file.
      2. Equal Intervals: The minimum and maximum values of the selected fields are determined. The range is split into equal sized sub-ranges. Records are assigned to bins based on these ranges.
    3. Edit the Number of Tiles (max of 1,000) counter to specify how many bins you want to create.

View the output

Output includes all fields that went into the tool and a nThe output data stream includes all fields that went into the tool. A new field will be created for each field that is selected for binning.ew field for each field selected for binning.

FieldName_Tile_Num

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.