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?
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.