Clay Icon
Join the Community
02 Support

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

Avatar of Dave S.Dave S.
·
·

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

5 comments

  • 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