video1.0<iframe src="https://www.loom.com/embed/ad767e3be9914d19a2f6647efe4dfa85" frameborder="0" width="1778" height="1333" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>13331778Loomhttps://www.loom.com13331778https://cdn.loom.com/sessions/thumbnails/ad767e3be9914d19a2f6647efe4dfa85-00001.gif716.97In this video, I demonstrate how to utilize lookup integrations in Clay to pivot information between tables. I showcase examples of referencing data across tables and enriching records efficiently. Action requested: Watch the demo to enhance your understanding of lookup functionalities in Clay. IMPORTANT NOTES: - You can find your Clay API Key by clicking on your account on the top right corner -> Settings -> API Key tab. - Lookup Single or Multiple Rows integrations won't return empty fields. For example, if you have a column with no values/data in Table 1, then that field will be skipped by the lookups in Table 2 (or within itself) - The older version of these integrations called Lookup Record in Other Table can and still returns columns even if they don't have any data.