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?
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 .
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.
still not sure