Hi Team, How can I take an empty table and relate it to the find people and company tables in order to pull data from it?
You can use the "write to table" feature to relate your empty table to existing Find People and Companies tables. This allows you to: 1. Create custom relationships between tables 2. Pull data while maintaining relational links 3. Extract specific attributes while preserving associations For company data, use the "Lookup Multiple Rows in other Table" feature with company domains as your matching data point. When you need people data, you can set up a lookup column in your empty table that refreshes whenever changes are made to the Find Companies or Find People tables. This approach creates an integrated dataset that combines both individual and company information seamlessly.
It dosent work
Yep, Lookup Row is the way to go here—great call. You can use either the domain or company LinkedIn URL as the ID. Here’s a quick walkthrough: loom.com/share/ad767e3be9914d19a2f6647efe4dfa85 Let me know if you have more questions.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.