.png){kind=logo}
Troubleshooting Lookup Single Row Function in Clay Table
Hi I am trying to use the lookup single row in other clay table function but it is not finding any tables for me to search from
Owen C.··Hey there, thanks for reaching out! Do you mind sending the link to the table so we can take a look? :) https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1731111300&signature=0ea3123906ba7f5f810bde7afd1a13bc542fab96159ac95bea8f9500ada3b2d4&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSr9B5YV2BKsam%2FhVPvvcg%3D%3D%0A
Leti B.··Hi Owen https://app.clay.com/workspaces/331716/workbooks/wb_mjHvDpHKvTHy/tables/t_PdMVZzSgBjwi/views/gv_ZqWEdryHu54J I am wanting to look up data from this table https://app.clay.com/workspaces/331716/workbooks/wb_mjHvDpHKvTHy/tables/t_RCFFrzGeDSs8/views/gv_zV8sXGAcjdYS & this table https://app.clay.com/workspaces/331716/workbooks/wb_mjHvDpHKvTHy/tables/t_P6DynVbnku5X/views/gv_s8EKgHv49RXA
Hey there thanks for sharing this, jumping in for Owen here. Just to clarify you are trying to run the Lookup from the Matches Table in the "Rising" Workbook correct? If so, this will not be possible as the way that the Lookup Multiple Rows in Clay works is that it searches for a matching data point between two tables. For example, you have a company domain column in table one and you run the Lookup it will search in table two's company domain column to see if any of the data point in the domain column of table also exist in table twos company domain column. The following video goes into detail on how this lookup workss. https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9?sid=92875867-14ec-4d32-81cd-d5a405b3e1e0
- Leti B.··
Thank you!
- Leti B.··
Thank you for sharing this video. I am still not understanding. Is there a template you can share with me that has an example of the lookup row in another table in clay feature working? I would like to see how it works and replicate it so I can learn how to do it in my own tables. Or are there more detailed instructions than the docs or a youtube video where I can try to replicate someone else doing this?
Bo (.··Hey, thanks for reaching out - Happy Saturday 😎 I've recorded a video here: https://cln.sh/dNH7PlBg Basically the reason why it's not working was because the API Key wasn't right. [App: Article Inserter] [App: Article Inserter]
- Leti B.··
thanks for your help!
