Band By Strata - Data360_Analyze - Latest

Given an increment value, assigns a band number to each value based upon distance, in number of increments, from zero.

An additional field is appended to each input row to identify that row's band.

Bands start at zero and are as wide as the Increment property. They are calculated in both directions from zero. Values that are zero are in a separate band. In other words, zero is its own band, then zero to increment, then increment to 2*increment, etc., plus -increment to zero, -2*increment to -increment, etc. In each case, the value that defines the band that is the closest to zero (i.e. has the lowest absolute value) is excluded from the band. Null values are put into a band with a null value.

Bands are numbered with integers in the BandFieldName field, starting at zero for zero values, then 1 for the first band above zero, 2 for the second, etc. For negative input values, the first band just below 0 is numbered -1, the second, -2, etc.An example might help clarify this explanation. If Increment is 5, then the first band is the 0 band. Only values of 0 are put in the zero band. Values from 0, exclusive, to 5, inclusive, are in band one. Band two contains all values from 5, exclusive, to 10, inclusive. Conversely, -5, inclusive, to 0, exclusive, is band -1 while -10, inclusive, to -5, exclusive, is band -2. All values that fit in these bands are marked with the appropriate band number.