Sayeem A.

Hi Luis - Here's the URL: https://app.clay.com/workspaces/525195/workbooks/wb_0t2csf0gNWTf2EpXom4/tables/t_0t2csgtzy4U9CdsDMCi/views/gv_0t2csgtU3GfbxqMdXW4 If you go to the "Day1Table" column > click record found > record > "Enrich Person". You'll notice it's a text of the leads name whereas in the Master clay table i'm referencing it's an object of much more information about the lead

Hover over the nested field you want (e.g., title, summary, certifications) and click "Add as column." This creates a child column for that specific endpoint, preserving its structure for downstream use.

I'd like to avoid this approach, it feels like it'll really clutter up the master lead clay table with how many fields are available when Enriching a person

use a lookup that references the entire enrichment, not just a text value.

When using the "Lookup Single Row in Other Table" i don't think there is an option to specify the field type, it just spits out everything afiak

When setting up your lookup, select the option to "Insert all properties" from the enrichment column—this will preserve the full object structure, allowing you to access nested fields directly.

I don't see this option when using "Lookup Single Row in Other Table"

Extra details: • Master table column name: “Enrich Person.” • Keys used for the lookup: [lead_email]. • Expected: a structured object I can access like EnrichPerson.title, EnrichPerson.summary, EnrichPerson.certifications[0], and similar. • Actual: a single text string.