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?

6 comments

Clay
APP
·
·
You do not need to add a separate lookup field for each extracted name. After using "Extract Values" to get your list of company names, you can reference the resulting array and use the "Lookup Multiple Rows in Other Table" action. This allows you to dynamically match all extracted company names against another table in a single step, streamlining your workflow and avoiding manual setup for each name.
Sources: Lookup Rows | Documentation | Clay University Extract Values from Data with Clay Referencing dynamic data from other columns | Documentation | Clay University
Ari G.
·
·
how?
Ari G.
·
·
human
Ari G.
·
·
https://app.clay.com/workspaces/11277/workbooks/wb_0sybgpdnKYa4hqQ7t2B/tables/t_0sybgq2TGGNwZt86zyr/views/gv_0sybgq49CmgKV7Z5iQn
Ari G.
·
·
help please
Daniela D.
·
·
Hey Ari! Truly sorry for the delay. Happy to help🙏🏾. The table linked doesn't include an "extract values" column, but I noticed a column named "GC_names" pulled values from the Salesforce action. To confirm, you want to be able to run a Lookup against all names in each column to verify if at least one exists in a different table? Could you share the table you want to run the "lookup" action for? You may be able to achieve this if you set the filter operator (for "lookup rows) to "contains".