AN_DINT comparison

Compares an alphanumeric string from a data source to two alphanumeric intervals from a reference source. You can use this comparison to compare house numbers with census, Etak, GDT DynaMap, postal code, or other files.

Frequency information is not taken into account when this match comparison is used but a two-source match requires four input streams. If you use this match comparison with a Two-source Match stage job, create two dummy file inputs instead of files that contain frequency information.

Required Columns

The following data source and reference source columns are required:

  • Data. A column from the data source that contains numeric values.
  • Reference. The reference column that contains the beginning value of the first interval (such as the left side of the street) from the reference source.
  • Reference. The reference column that contains the ending value of the first interval from the reference source.
  • Reference. The reference column that contains the beginning value of the second interval (such as the right side of the street) from the reference source.
  • Reference. The reference column that contains the ending value of the second interval from the reference source.

Example

A single house number, which might contain alpha characters, is compared to two intervals. One interval represents the left side of the street and the other represents the right side of the street.

For example, 123A is compared to the intervals 101-199 and 100-198. For a number to match to an interval, both the parity (odd/even) and the range must agree. This comparison causes a special flag to be set to indicate whether the left or the right interval matched.

The beginning number of an interval can be higher than the ending number and still match. Files can have a high address in the FROM column and a low address in the TO column. For example, 153 matches both the range 200-100 and the range 100-200.