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

Dave S. · 2024-02-14T22:59:21.516713+00:00

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

Dave S.

·

https://app.clay.com/workspaces/43672/tables/t_rdmh8cuKkIJ9/views/gv_caMU2e5nK5ao

Clay T.

APP

·

Hey Dave! Just tagged you in a recent update we had but I'll check the table in a bit

Dave S.

·

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

APP

·

checking now

Clay T.

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

5 comments