Clay Icon

How to Lookup Record in Other Table using Matching Key for Validation?

ยท
ยท

Hello! I had a quick question about the "Lookup Record in Other Table" enhancement. I have a Company table that I want to reference in my People table. Using the company domain as a matching key between the two tables, I want to see if the target field in the Company table has data. If it does, I want to copy that data for the contact in the People table, and if it doesn't I want to output "N/A". What's the best way to accomplish this? Company Table: https://app.clay.com/workspaces/147954/tables/t_TcEnPug8jybB/views/gv_vgM83MqMppQk People Table: https://app.clay.com/workspaces/147954/tables/t_8FoBJDInohSK/views/gv_JOWFMyhuCCJO