Find Closest Adv
Overview
The Find Closest Adv macro finds the closest Right records for each Left record using either latitude/longitude or spatial data. It includes options for number of records to find, distance limit, and distance units. You may also filter matches using optional area fields.
Find Closest Adv macro configuration parameters
The Find Closest Adv macro has a single set of configuration parameters.
Left fields
Parameter | Description |
|---|---|
Left record ID | (Required) Field containing unique record identifier from left input table.
|
Left latitude | Required if Left spatial is not defined. Field from left input table containing latitude.
|
Left longitude | Required if Left spatial is not defined. Field from left input table containing longitude.
|
Left spatial | Required if Left latitude/longitude are not defined. Field from left input table containing spatial data.
|
Right fields
Parameter | Description |
|---|---|
Right record ID | (Required) Field containing unique record identifier from left input table.
|
Right latitude | Required if Right spatial is not defined. Field from left input table containing latitude.
|
Right longitude | Required if Right spatial is not defined. Field from left input table containing longitude.
|
Right spatial | Required if Right latitude/longitude are not defined. Field from left input table containing spatial data.
|
Setting
Parameter | Description |
|---|---|
Top N | (Optional) Number of matching right records to find, ranked by proximity.
|
Distance limit | Optional. Limit matching records to those within defined distance.
|
Unit | (Required) Unit of measurement, either KM (kilometers) or MI (miles).
|
Restrict match by area
Parameter | Description |
|---|---|
Right area field | (Optional) Fields from left and right input tables used to limit matches to specified area. In practice, this means that left and right fields must join on these key fields to match.
|
Configure the Find Closest Adv macro
Select the Find Closest Adv icon.
Go the Configuration tab on the Properties pane.
Define left and right input fields:
Select Left Record ID and choose the field containing the unique record ID for the left input table.
Select either Left Latitude and Left Longitude or Left Spatial, and choose the left spatial data input fields.
Select Right Record ID and choose the field containing the unique record ID for the right input table.
Select either Right Latitude and Right Longitude or Right Spatial, and choose the right spatial data input fields.
Optionally, configure Settings:
Select Top N and specify the number of matches to return, ranked by proximity.
Select Distance Limit and specify the maximum distance for matching records.
Select Unit and choose the unit of measurement, either KM (kilometers) or MI (miles).
Optionally, Restrict match by area.
Select Left Area field and Right Area field and choose fields (such as STATE) that limit matches to a specified area. The left and right fields must match in order to return the closest Right records for each Left record.
Optionally, go to the Execution tab, and then set Web service options.