How to Efficiently Perform a Lookup in Another Table with Multiple URLs

·

hey, im trying to do a lookup in another table: https://app.clay.com/workspaces/16502/tables/t_jlJqXTN505GK/views/gv_028nZVY3yAxV I have 50 urls in a single cell and want to match them. Outside of seperating them into 50 columns with 50 lookups, is there a way to do this more efficently?

· Sorted by Oldest

Clay Team
APP
·
·
Hey Jamie! It may be easier to pull that list of domains into a new table where you run the lookup for each one, and then a lookup in your original table to pull any matches to the corresponding source/row.I'll test something out in case you see something added
Adam Eldefrawy
·
·
Jamie Mumford I modified your prompt here to make sure it returns in a list - there was a slight technical difference between an object that it was returning and a "list" in JSON - let me know if that works alright for you

Clay Team
APP
·
·
Hey Jamie! It may be easier to pull that list of domains into a new table where you run the lookup for each one, and then a lookup in your original table to pull any matches to the corresponding source/row.I'll test something out in case you see something added
Adam Eldefrawy
·
·
Jamie Mumford I modified your prompt here to make sure it returns in a list - there was a slight technical difference between an object that it was returning and a "list" in JSON - let me know if that works alright for you