Hey all! I have a People list, where in some cases there's 8-10+ contacts from the same company. How can I consolidate this list so there's only 3 contacts max at each company? Is this possible in Clay, or easier in Google sheets, how would you do this?
Hey Alexander! Thanks for reaching out. Happy to help. The workaround for this is assigning a number position progressing from 1, for each contact per company in the table. Once that is done, you can filter your table and remove any contacts that are not assigned a number between 1-3 for each company. Here's a quick video explaining how to set this up: https://www.loom.com/share/a39a4569d95244b7886026f3c70812c7 This workflow is typically used to prevent duplicate records from getting enriched, but can also be applied to this. Let me know if you have any questions.
