.png){kind=logo}
Integrating Two Tables of Companies for Data Retrieval
Hi, i have two tables with companies. I would like to find people from both tables. Is it possible? Or can i integrate both table to one? Thanks
Hi, i have two tables with companies. I would like to find people from both tables. Is it possible? Or can i integrate both table to one? Thanks
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Hi Inbar, thanks for reaching out. You should be able to merge your two company tables using a write to table enrichment column. Here's a video showing you how to set up a write column. Find and set up the write to table enrichment column by clicking on Add Column > Add Enrichment > Search and select "write to table" https://downloads.intercomcdn.com/i/o/1185975990/ed304d8ca35684a69d548fa8/CleanShot%2B2024-09-04%2Bat%2B22_37_07.gif?expires=1726761600&signature=d0577e4121b1e7f6385c1e94428058d983d3d2a070058087a6d371a635120580&req=dSEvE8B5mIhWWfMW1HO4zfJqeTj7Vm14%2B7f5Fx7K38QdyRVTTVsHJ%2BpdiCmE%0ALTSj%0A You can now choose to parse your arrays into an existing table or create a new blank table for them, by clicking on "new table": https://downloads.intercomcdn.com/i/o/1185975989/8074fcb4abea9069323d92f4/CleanShot%2B2024-09-04%2Bat%2B22_45_05.gif?expires=1726761600&signature=91b7f3c56720305376347edc88ac62db65f88e412d18a0b7cc97e7d2a8b9309d&req=dSEvE8B5mIhXUPMW1HO4zeHcTSob45ubO3CtMWoEV3xZsIyrAw7T%2Bc5%2FlMyv%0AATxJ%0A You'll now be able to add other column values to the table, which is useful when transferring lead data from one table to another using the 'Write to Table' column. https://downloads.intercomcdn.com/i/o/1185975992/e13f456d148640b328e36954/CleanShot%2B2024-09-04%2Bat%2B23_00_35.gif?expires=1726761600&signature=00458ba804f9d732607c49842cdd0d4714ea7d2697ccebbbc556c03beaa5fbd2&req=dSEvE8B5mIhWW%2FMW1HO4zUzhVZ98RiMXluuFEbgJ4pi00ldjQD80KJ1eaBXh%0AKPJ%2B%0A You're all set! You can now save and run your 'Write to Table' column.
🙏
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
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.