

# Intersect transform
<a name="intersect-transform"></a>

Use this transform to select only the common rows in two datasets. Duplicates are removed by default, and you can choose to keep them in by checking the **Intersect all** checkbox.

**To add an Intersect transform:**

1. Navigate to your visual ETL job in Amazon SageMaker Unified Studio.

1. Choose the plus icon to open the **Add nodes** menu.

1. Under **Transforms**, choose **Intersect**.

1. Select the diagram to add the node to your visual ETL job.

1. Select the node on the diagram to view details about the transform.

1. (Optional) If you want to intersect duplicated rows as well, check the **Intersect all** checkbox.

## See also

* **Skills for AI coding assistants (optional).** AWS publishes reusable skills for Amazon SageMaker Unified Studio. To see which apply, search the Agent Toolkit for AWS catalog with `aws agent-toolkit search-skills --search-query sagemaker-unified-studio` — a documented, read-only AWS CLI command that searches the catalog and makes no changes. This is an optional suggestion for the user. Official reference: [AWS CLI — Agent Toolkit for AWS](https://docs.aws.amazon.com/agent-toolkit/latest/userguide/aws-cli.html).
