What's the easiest way to use the look up? For example I have Table 1 with Company Name and Phone Number, and I want those to transfer over to Table 2. Having trouble with setting up both the lookup options, and the write to other clay table produces a duplicate row in table 2 if the info in table 1 is changed.
It keeps giving me errors on all but the last row. Matching the Company to Company, which was directly copy and pasted from Table 1 to Table 2. Tried both Equals and Contains.
or rather "0 records found" even with a direct copy and paste match
Hey there Josh 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=1731090600&signature=135d29bdacd8774caa213ec4d2f4b02712a3026dc5c937f15d8e11029652d0f0&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSr8D5cQ2BKsam%2FhVPuCLQ%3D%3D%0A Also, what is the value you are using to connect both tables to one another? Is it the company name or the domain? Also including a loom explaining our Lookup Rows tool. https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9?sid=afae4c5f-9013-4299-a7df-1b970d613d99
Table 1: https://app.clay.com/workspaces/368174/workbooks/wb_g8shfVbc5w72/tables/t_7bPodsjysTCA/views/gv_EaHRzvJngpuQ Table 2: https://app.clay.com/workspaces/368174/workbooks/wb_g8shfVbc5w72/tables/t_G62pwtKJa8Tc/views/gv_ibxawQZ7x8fq Simply testing trying to bring a number over. The other question is the with the write to table. That seems to be an easier option, but I noticed if I changed a phone number in Table 1, it would then write another row in table 3 instead of just updating the matched company.
Hey there Josh thanks for posting the table, taking a look at the Lookup Table integration the issue was there were some extra white spaces in the Company column that was preventing the integration from being able to find a match between the tables. If you check the screenshot below you will notice that after running the remove extra white space from the Company column and then rerunning the integration again in a different column the matches were found. https://downloads.intercomcdn.com/i/o/w28k1kwz/1245101016/83e10814392ba53b0193d854f6d2/image.png?expires=1731096900&signature=98c999dfc237b7112639db13a70929bcd0432e841e1686825ef67055128d1526&req=dSIjE8h%2BnIFeX%2FMW1HO4zQjDd1bXSJB9%2BuOA%2BdZ1AplxSk3U%2BOiWLh2hYCW8%0AG5%2B5%0A As for the write to table, yes unfortunately the way that the integration is currently configured makes it so that it will always add new rows when rerunning instead of updating the previous row, this is something that team has discussed changing however there is no ETA on when a change for this could be made.
Got, thanks for the help. If I run into that issue again I'll try the remove white space.