Hi Team, I'm trying to use the lookup record function and struggling. The table I'm pulling from is this one: https://app.clay.com/workspaces/346206/tables/t_Hizjx8bwPS3Z/views/gv_RihWVvEgrkCG and it's the last populated column. I'm trying to import that to this table here: https://app.clay.com/workspaces/346206/tables/t_onZyWjJrouep/views/gv_BuRUCpddRec9 . Whatever I put in row value, it's coming up with a blank result.
๐ Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Hey there Mark thanks for reaching out, this happening because when using the Lookup Row in Table integration, the "Target Column" and Row Value" filter should both have a matching data point in order to make a connection. This integration works by looking for any similar data points with which to make a connection between tables and since the Job Title and Company domain are not similar it is finding any matches. https://downloads.intercomcdn.com/i/o/1171521604/c9b69b8447884a97d4857b47/image.png?expires=1725651900&signature=a4fc863ddf4d6e9c816ed1d71cb9c3bdfed4cf4071ab2f4ced5c417968cf7e5d&req=dSEgF8x8nIdfXfMW1HO4zZBALzmCz%2BN6ZcHn9b837Zmvc%2Bgnk0PA%2BvJ8m2f%2B%0AB5%2B%2B%0A I switched the "Target Column" to look for company domain and ran the integration and it is now finding matches between both tables. https://downloads.intercomcdn.com/i/o/1171524429/aa1c14001afd9d30eea864ae/image.png?expires=1725651900&signature=7fef3122c496abceebd13eed1e44a52109dbef0cb7a043074042c77b48cc235c&req=dSEgF8x8mYVdUPMW1HO4zaiQGNa%2FLSaic3xFo8H%2F8D0X7Ejhp4%2B82Spljdas%0ALV3q%0A
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
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.