Multi-Column Binning Tool
Use Multi-Column Binning to replicate some of the functionality of the Tile tool—additional features allow the data to be binned on multiple columns. Multi-Column Binning only accepts numeric columns for binning. You can bin columns on either equal rows or equal intervals.
Configure the Tool
In Numeric Columns to Bin, use the check boxes to select the columns for binning (only numeric columns are shown.)
Note
If too many rows have the same group value, a tile is skipped.
Choose the tile method you are going to use for binning. The options are:
Equal Rows: Input rows are divided into the specified number of bins. Each bin is assigned the same number of rows. This is based solely on the row's position in the input file.
Equal Intervals: The minimum and maximum values of the selected columns are determined. The range is split into equal-sized sub-ranges. Rows are assigned to bins based on these ranges.
Enter a number between 1 and 1000 in the Number of Tiles counter to specify how many bins you want to create.
View the Output
The output data stream includes all columns that went into the tool. A new column is created for each column that is selected for binning.
ColumnName_Tile_Num