Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Fixing Lookup Row Discrepancies in Enrichment Run Table | Clay

Fixing Lookup Row Discrepancies in Enrichment Run Table

·Aug 21, 2025 07:59 PM·

Hi - in the table "Enrichment Run - FINAL" - I have a filter that includes single lookup row from other table (in the contacts for enrichment table), however, those numbers consistently don't match. How do I get these to always match? https://app.clay.com/workspaces/339088/workbooks/wb_0sz3fhtXTp5R3BSq6gH/tables/t_0szi9axbwUVeGHiZiUc/views/gv_0szi9ayXzJraUSUipAW

2 comments

· Sorted by Oldest

Clay
APP
·
·
The lookup single row enrichment can only filter using one column at a time, which may cause mismatches when you need multiple criteria. To improve matching accuracy: • Use a unique identifier - Email addresses work best as lookup values since they're typically unique • Check your filter settings - Ensure you're using "equal to" rather than "contains" for exact matches • Verify the lookup column - Make sure the column you're searching in actually contains the values you're looking for If you need to match on multiple criteria, consider creating a merged column that combines the values you want to match on, then use that as your lookup field.
Sources: Hide, Re-order, Sort, Filter, Merge Columns Google Sheets integration overview | Documentation | Clay University
Nicole B.
·
·
Can I please have someone take a look at this?