Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Hire GTME Talent
Explore Events

Powered by Tightknit

How to Merge Multiple People Enrichment Arrays into a Single Table in Clay | Clay

How to Merge Multiple People Enrichment Arrays into a Single Table in Clay

·Feb 04, 2026 05:09 PM·

I am running two different people enrichments in Clay and both return multiple contacts per company. What is the cleanest way to merge both arrays and convert them into a single person level table?

3 comments

· Sorted by Oldest

Clay Support
APP
·
·
You have two great options to merge those arrays and create a person-level table:
Option 1: Merge Columns First
1.
Click Add column → Merge columns
2.
Select your data type and write a formula including both people enrichment columns with /
3.
This combines both arrays into one column [1]
Option 2: Send Each Array Separately (Recommended)
1.
Go to Exports → Send table data
2.
Choose Send row for each item in a list
3.
Select your first people enrichment column
4.
Repeat for the second column to the same destination table [2] [3]
The second option is cleaner because it flattens each person from both enrichments into individual rows automatically, giving you a proper person-level table where each row represents one contact [4]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you need any more help with merging your enrichment data or creating a person-level table, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?