Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Dynamically Lookup Company Names in Extracted Values List

·

·

I have a comma separated list I used extract values to extract each company name into its own field I then want to look up each one of those names and match against another table. Is there an easy way to do this dynamically or do I need to add a separate look up field or each name that was returned in extract values?

Loading attachments

Dynamically Lookup Company Names in Extracted Values List | Clay

3 comments

· Sorted by Oldest

Clay
APP
·
·
To dynamically match each company name from a comma-separated list against another table, use the "Write to Table" feature to split the list so each company is in its own row in a new or existing table. Then, use the "Lookup Multiple Rows in Other Table" action to match all company names at once, without needing a separate lookup field for each name. This approach automates the process and avoids manual setup for each extracted value .
Sources: Referencing dynamic data from other columns | Documentation | Clay University Find Your Next Customer with Company Lookalikes - Clay University Lookup Rows | Documentation | Clay University
Channeled
APP
·
·
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.
Ari Goldstein
·
·
still not sure