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.