Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

Fixing Lookup Row Discrepancies in Enrichment Run Table

·

·

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

Loading comments

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?