I have a list of customers in one Clay table and in another table I have a list of customers with an associated account lead. Since the customer names aren't always consistent I was going to use Chatgpt to compare them and indicate the account lead for the matching customer. How would I do that? Can I do cross table comparisons like that with ChatGPT?
๐ 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 Freddie! Thanks for reaching out. Just to confirm, you'd like to check for matching customer records in one table to reference in another table? It's currently not possible to run a table comparison with ChatGPT, but you can run Lookup between tables to check for matching data to make comparisons. If the customer names are not consistent between both tables, you can normalize the structure and format with the "Normalize company name" feature. If you can share your table urls (link in browser tab), happy to take a look as well to better understand your use-case and share additional suggestions, if needed. Here's a quick for using Lookup: https://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85?sid=c8b78c32-9bc1-4501-8124-d6c70d2218cf https://downloads.intercomcdn.com/i/o/1178170280/e078bf8360d02d234491be59/CleanShot+2024-09-12+at+19_29_55%402x.png?expires=1726167600&signature=1e446352e577606aac39d6109e6aaf56c1861a7a3842f608e0ec14c2f6c3838b&req=dSEgHsh5nYNXWfMW1HO4zZyEuGRp6IeZIDijhuPPzX0Fl%2Fd47rMVhLT5iNxu%0AKQqW%0A
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.