Filter Table 1 to Exclude Companies in Table 2

·Jul 08, 2025 03:15 PM·

I have 2 data tables containing lists of companies. I want to apply a filter to Table 1 so that it only shows companies that are NOT present in Table 2. How can I do this?

1 comment

· Sorted by Oldest

Clay
APP
·
·
To filter Table 1 to show only companies NOT in Table 2, use the Lookup Single Row in Other Table action: 1. In Table 1, add a column using Lookup Single Row in Other Table 2. Set Table to Search as Table 2 3. Configure the lookup to match company identifiers (name, domain, etc.) 4. Click Filter above Table 1 5. Select the lookup column and choose is empty This will show only companies from Table 1 that have no match in Table 2.
Sources: Customize your table view | Documentation | Clay University Hide, Re-order, Sort, Filter, Merge Columns Lookup Rows | Documentation | Clay University

Clay
APP
·
·
To filter Table 1 to show only companies NOT in Table 2, use the Lookup Single Row in Other Table action: 1. In Table 1, add a column using Lookup Single Row in Other Table 2. Set Table to Search as Table 2 3. Configure the lookup to match company identifiers (name, domain, etc.) 4. Click Filter above Table 1 5. Select the lookup column and choose is empty This will show only companies from Table 1 that have no match in Table 2.
Sources: Customize your table view | Documentation | Clay University Hide, Re-order, Sort, Filter, Merge Columns Lookup Rows | Documentation | Clay University