Michael R.

Thanks! Daniela D., when I do that, and I run into multiple rows, how can I then use the data of the most recent row in another column?

Okay thanks. I assume this cannot be changed to newest? Daniela D.

Hey Daniela D.. Thanks for the explanation. Do you mean the first row based on the sorting that I set?

https://app.clay.com/workspaces/496537/workbooks/wb_0t503febG74FzXMQtiC/tables/t_0t503feQPRfuATgnonJ/views/gv_0t4ubeluP3ihxWHnXEU

This is not really helpful. I don't want to spent AI credits on this. Could you just tell me which row would be retrieved when I use the lookup on a single row?

Okay, and how do I select the most recent one?

We just want to return the most recent one

I'm using equal. I'm using domain as a lookup value. However, the table connected table does contain duplicates (it's a cache for enrichments, where we store all enrichments)