âShow Table of Contents
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.
Select the fields for binning (only numeric fields are shown): use the checkboxes to select the numeric fields for binning.
Tile Method: choose the tile methods for binning. Choices are
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 the numeric up/down selector to specify how many bins to create.
Output includes all fields that went into the tool and a new field for each field selected for binning named 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.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.