Clay Icon

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

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

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

  • Avatar of Dave S.
    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

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    checking now

  • Avatar of Clay T.
    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