Skip To Content

Filter by attribute

The Filter by attribute tool returns a subset of a dataset based on a query. The output is a new dataset containing only the records that meet the condition specified in the query.

Examples

The Filter by attribute tool can be used in scenarios such as the following:

  • Filter out records that do not have a geometry.
  • Retain only the records that have a specific ZIP code.

Parameters

The following table outlines the parameters used in the Filter by attribute tool:

ParameterDescription

Input dataset

The dataset to be filtered.

Filter expression

The SQL query that will be used to filter the input dataset.

Usage notes

Use the Input dataset parameter to identify the dataset to be filtered.

To filter a dataset, use the Filter expression parameter to specify an expression that identifies the records you want to maintain. The expression must return a Boolean value. Records that meet the conditions of the expression will return true and will be maintained in the result. Records that do not meet the conditions of the expression will return false and will be excluded from the result.

Outputs

The tool output is a dataset containing only the records that met the condition specified in the filter expression. The output dataset will contain all fields from the input dataset.

Limitations

The following are known limitations of the Filter by attribute tool:

  • If a string field is selected in the query builder, the choice list will populate with a list of unique values based on the preview records only. This is not a complete list of unique values in the source dataset.
  • The tool returns a single dataset that contains the records that matched the specified expression. The records that do not meet the specified expression will not be returned. To create a dataset containing the records that were excluded, run the tool again using the same input dataset and the inverse of the query you used the first time.

Licensing requirements

The following licensing and configurations are required:

  • Creator or Professional user type
  • Publisher, Facilitator, or Administrator role, or an equivalent custom role

To learn more about Data Pipelines requirements, see Requirements.