{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/a39a4569d95244b7886026f3c70812c7\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/a39a4569d95244b7886026f3c70812c7-00001.gif","duration":378.76,"title":"Prevent Duplicate Records from Getting Enriched","description":"IMPORTANT: If you're experiencing odd behavior, please reach out to use directly at -- support@clay.com -- so the team can troubleshoot for you. Some things can \"break\" because of how programming languages may interpret some values which may be a bit more technical to spot. \n\nYou can use the latest version of Lookup called Lookup Multiple Rows too, not just the one in this video :)\n\nIMPORTART NOTES: Make sure that your column is spelled/named exactly the same as what you tell the prompt below to look for i.e. Column name = UniqueID so I'll prompt to search for \"UniqueID\"; example 2: Column name = Unique Number so I'll as the prompt to search for \"Unique Number\"...\n\nThe Column type i.e. Text or Number shouldn't matter, but if you do notice issues, changed both to Text.\n\nPROMPT:\n\nOnly run if /{UniqueID} is not empty, then return a number label depending on which number of occurrences any of the \"UniqueID\" fields from the following array /{lookup} match /{UniqueID}\n \nFor example, if the first value of \"UniqueID\" you find from the array is true, then return 1, if it's the second value then return 2 and so on\n\nOtherwise return 2"}