Find Nearest Tool
Use the Find Nearest tool to identify the shortest distance between spatial objects in one file and the objects in a second file.
There are many uses cases for the tool. For example, use the tool to find the closest store locations to consumers in the customer file (both point files), identify the closest cell towers (point files) to LATAs (polygon files), or select congressional districts (polygon files) within 50 miles of a major thoroughfare (line file).
A Universe input connection into this tool is optional, as this file can be specified with an input path.
If using DriveTime, see Guzzler Drivetime Methodology for more information.
Configure the Tool
The Find Nearest Point tool accepts two spatial inputs.
- Select the Spatial Object Field to use for the Targets (T Input). Any object type can be chosen for the Target, but if it is a not a point type object, the centroid is used for analysis.
- Specify the Universe object.
- Use Records from U Input: Select the Spatial Object field from the data going into the tool.
- Use Records from File or Database: When reading in spatial objects from a data source, make sure the data source that is being brought in has already been sorted on the spatial object. Ensure no connection is going into the U input.
- To specify the input data source, either enter the file path location of the input or browse to the data source's location.
- Select the Spatial Object Field from the input data source to calculate the nearest distance to.
- How many nearest points to find?: Specify how many nearest Universe objects to find for each Target. The default is 1. The Find Nearest tool can return more records than selected in the “How many nearest points to find?” field if there are multiple records in Universe the same distance from the Target object.
- Set the Maximum Distance and units of measure these objects can be from the Target. If Drive time is to be calculated, the user can specify the dataset they wish to use to calculate this figure. If only one dataset is installed, you will not have the option to select another dataset. You can specify the default dataset from User Settings. Go to Options > User Settings > Edit User Settings and select the Dataset Defaults tab.
- Choose whether or not to Ignore 0 Distance Matches. When checked, a point never matches to itself. If you are expecting the same number of input records as output records, ensure you do not have any duplicates in your data stream.
- Use the table to modify the incoming data stream. Each row in the table represents a column in the data.
Select, Deselect, and Reorder Columns
To include a column in data, select the check box to the left of the column name. Deselect the check box to exclude the column.
To reorder the columns of data...
- Select to highlight a row, or drag down to highlight multiple rows.
- Click the up or down arrows, or right-click and drag, to move the rows to a new location.
The Unknown column is selected by default. It allows new columns in the data. Move the column to the location where you want a new column to be.
Modify Data Type and Size
To change the supported length (characters for string and numeric fixed decimal types) or measurement (bytes for other numeric types) of data in a column, select Size and enter a number. Size varies by data type and can be edited for fixed decimal numeric types and all string types. See Data Types.
Use the [data type]: Forced option to ensure a column always contains the expected data type; this is helpful when creating macros. See Macros.
Rename a Column or Add a Description
- To change the name of a column, select a field in the Rename column and enter the new name.
- To add a description, select a filed in the Description column and enter a description.
View More Options
After you select or highlight rows (columns of data) in the table, select Options to view more configuration options:
- Save/Load: Save the column configuration as a .yxft file. The Alteryx Field Type File is a text file can be used in other workflows using the Load Field Names or Load File Names and Types options.
- Select: Select or deselect all or highlight columns. Options include Select All and Deselect All.
- Change Field Type of Highlighted Fields: Change the data type of all highlighted columns at once.
- Sort: Sort the column order in ascending or descending order. Options include Sort on Original Field Name, Sort on New Field Name, and Sort on Field Type, or Revert to Incoming Field Order.
- Move: Move highlighted columns to the top or bottom of the list.
- Add Prefix to Field Names: Add a prefix to the selected or highlighted column name.
- Add Suffix to Field Names: Add a suffix to the selected or highlighted column name.
- Remove Prefix or Suffix: Remove the prefix or suffix from the selected or highlighted column name.
- Clear All Renames: Remove the new name for all columns.
- Clear Highlighted Renames: Remove the new name for all highlighted columns.
- Revert All to Original Type & Size: Undo all changes to type and size in all columns and use the original values.
- Revert Highlighted to Original Type & Size: Undo changes to type and size in the selected or highlighted columns and use the original values.
- Forget All Missing Fields: Remove all columns that are no longer included in the data.
- Forget Highlighted Missing Fields: Remove all highlighted columns that are no longer included in the data.
- Deselect Duplicate Fields: Deselect the second column when duplicate column names exist; this optional is only available with multiple inputs.