.png&w=3840&q=75){kind=logo}
Merging 80,000 Entries: Is It Feasible with the Starter Package?
Hi, I'm looking to merge several tables with a total of about 80,000 entries. Would this be possible with the starter package?
👋 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!
Bruno R.··Hi Nick, thanks for reaching out. We currently limit tables to 50k rows, 70 columns and 30 enrichments per table. We do this to ensure we can continue providing excellent performance across the board. In this specific scenario it looks like you'll have to set up two separate tables to hold your contacts. To merge your contacts into a single table you'll have to use the write to table enrichment, which will allow you to write your table records to the two tables of reference I previously mentioned. Here's a video showing you how to set up a write column. 1. Make sure your Clay API key is linked correctly. 2. 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/1198582233/2dc554c23ce99295e3229577/CleanShot%2B2024-09-04%2Bat%2B22_37_07.gif?expires=1727708400&signature=cd680dce0e3de1748567bca3b77939e080198acda742eb734cde6f8a13db7a52&req=dSEuHsx2n4NcWvMW1HO4zR4XOeNlN%2Bz9tSwkH3I7K4yXU68r5FtrdjEZFZ20%0AOCU4%0A 3. 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/1198582226/052369cca5acf453e408aa87/CleanShot%2B2024-09-04%2Bat%2B22_45_05.gif?expires=1727708400&signature=b419e753dff1aa2280c905585a26f151d7eb0899e0ef3b0185669771636a4880&req=dSEuHsx2n4NdX%2FMW1HO4zRfGVcdSeaRKzENE4LY6xS0UY2SVLRlT5ZJY56o7%0AsOVD%0A 4. We can now neatly write our array of objects into individual rows by inserting a column in the 'Select a List from a Column' field. Type a forward slash, choose the column containing the arrays, open its properties, and click "insert all items". https://downloads.intercomcdn.com/i/o/1198582229/774fb051e3f75186da03e1c4/CleanShot%2B2024-09-04%2Bat%2B22_53_01.gif?expires=1727708400&signature=5b0e085ade46126261b4aded76f3f6d132c93a7f5fcb8f23320e0cd678156185&req=dSEuHsx2n4NdUPMW1HO4zYxRufNS5T6gjaDI5Fq0RcW%2F%2FhArsvBjXBeMb7%2BT%0ALjRe%0A 5. Now the last thing we'll have to do is specify which objects from the array we want to write to the new table, and to which columns we want to map them. We'll be able to select columns which are existing or create new ad-hoc columns for this purpose: https://downloads.intercomcdn.com/i/o/1198582234/15e7eb22110dec4e85c5777b/CleanShot%2B2024-09-04%2Bat%2B22_55_01.gif?expires=1727708400&signature=fc19f3c6ba42380f1e55a854fb38bf465deae492015e735fe1fd9524569681d9&req=dSEuHsx2n4NcXfMW1HO4zdTJ1xB9DmQF9ugx1%2Bm%2Fr11lorWH0TVXyT1eKfry%0A2RsS%0A 6. You can also 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. This setup can work independently, without the list feature configured in step 4. https://downloads.intercomcdn.com/i/o/1198582232/a56c41ce0d07189e49dd5a45/CleanShot%2B2024-09-04%2Bat%2B23_00_35.gif?expires=1727708400&signature=40aeece10dc0cff2f71f3962f0a9dea666e20b7da67afc05e5f2d65439bbb851&req=dSEuHsx2n4NcW%2FMW1HO4zfUozWlZcHPGXwV79nywrS3nbpAD6yau%2FY%2Fp6eRp%0AE1cA%0A You're all set! You can now save and run your 'Write to Table' column.
- Bruno R.··
Hi Nick, sorry about the confusion here, please disregard the Intercom link I shared above. You should be able to link your API key following these instructions. Let me know if you have any other questions!
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!