{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/89162557968c424b8bdc91eeb85ab5b6\" frameborder=\"0\" width=\"1440\" height=\"1080\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1080,"width":1440,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1080,"thumbnail_width":1440,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/89162557968c424b8bdc91eeb85ab5b6-37c33d1cbf0928a6.gif","duration":142.422,"title":"Looking Up Multiple Rows in Data Tables 📊","description":"In this video, I discuss how to look up multiple rows in a table to count how many people work at companies I already know about. I demonstrate using a people table and matching it against a website column to find email domains. I highlight that Clay will count all records but will only display up to ten in the cell. I also show how to break out results into separate columns and emphasize the importance of taking action based on the counts, such as running a find people system if no records are found. Please consider how you might apply this method in your own work."}