Address Cleansing Results
After running an address cleansing job, several new columns are added to show the address cleansing result.
The following columns are added:
Column Name | Data Type | Description |
---|---|---|
addr_isLead | Boolean | true: This row is the result with the highest score. |
addr_group | Integer | -1: No result is found.
0: Only one result row is found. >0: Multiple results are found. |
addr_rowInddex | Integer | The row index of the source data. |
addr_longitude | Integer | The longitude of the source data. |
addr_latitude | Integer | The latitude of the source data. |
addr_city | String | The matched results returned from the address cleansing vendor. |
addr_state | ||
addr_zipcode | ||
addr_country | ||
addr_address | ||
addr_score | String | The third-party vendor gives a percentage score for each address data based on the matching degree. |
Copyright © Cloud Software Group, Inc. All Rights Reserved.