Having Trouble with Look Up Record Feature - Incomplete Results for Half Dataset

·

hey team, having an issue with look up record feature. It is not returning all records in the return. Oddly, for half the data set it is returning full records and the other half it is not

✅

1

5 comments

· Sorted by Oldest

Dave Shamula
·
·
https://app.clay.com/workspaces/43672/tables/t_rdmh8cuKkIJ9/views/gv_caMU2e5nK5ao
Clay Team
APP
·
·
Hey Dave! Just tagged you in a recent update we had but I'll check the table in a bit
Dave Shamula
·
·
Thanks, just checked it out. You'll see when you pop in. E.g. 100 rows are being looked up. 50 of them are not showing all the variables in the sheet. 50 are and are working fine
Clay Team
APP
·
·
checking now
Clay Team
APP
·
·
okay!! looks like you have duplicate emails in your original table, where those values come from and it only returns the first match it found which is not enriched. I'll DM you the examples Closing this thread

Dave Shamula
·
·
https://app.clay.com/workspaces/43672/tables/t_rdmh8cuKkIJ9/views/gv_caMU2e5nK5ao
Clay Team
APP
·
·
Hey Dave! Just tagged you in a recent update we had but I'll check the table in a bit
Dave Shamula
·
·
Thanks, just checked it out. You'll see when you pop in. E.g. 100 rows are being looked up. 50 of them are not showing all the variables in the sheet. 50 are and are working fine
Clay Team
APP
·
·
checking now
Clay Team
APP
·
·
okay!! looks like you have duplicate emails in your original table, where those values come from and it only returns the first match it found which is not enriched. I'll DM you the examples Closing this thread