https://app.clay.com/workspaces/600498/workbooks/wb_0sxdwt1V9XFVwoEjqQj/tables/t_0sxdwt1Yfqrdc8C3xzE/views/gv_0sws9jmPcBZuy6gob78 I want to break down this table to around 10 tables. e.g.
I want to select 140 items(quickly), save as a table 1
I want to select next 140 items, save to table 2
and so on
You can use the "Send table data" feature to split your data into multiple tables: 1. In your table, select the rows you want (first 140 items) 2. Click Actions → Send table data 3. Select a destination table (create a new one if needed) 4. Choose "Send row" and select which columns to include 5. Click Save Repeat this process for each group of 140 items. Note that Clay has a maximum limit of 10 connected tables across workbooks.
is there any way select mutiple rows? not one by one?
Yes, you can select multiple rows at once when splitting your table. Use the "Rows" button in the toolbar to set a specific range: 1. Click "Rows" at the top of your table 2. Enter values for "Starting Row" and "Row Limit" (e.g., rows 1-140) 3. Click "Save Changes" 4. Then use Actions → Send table data to send those rows to another table Repeat this process with different row ranges for each new table.
https://app.clay.com/workspaces/600498/workbooks/wb_0sxfie3TE92Fwj7d45P/tables/t_0sxfie3ypTsioZktpih/views/gv_0sws9jmPcBZuy6gob78 I duplicated this table, and instead of simply copying the data, it re-ran and generated the same data which consumed my credits. Is there any way I can get my credits back? Thanks
Hey — duplicating a table doesn’t carry over the underlying data, which is why it re-ran the enrichments and used credits again. That’s expected behavior since the data provider has to fetch fresh results. For splitting the table into chunks (like 140 rows each), you can create filtered views by selecting ranges, then use Send Table Data to move each group into a new table. Let me know how many credits were used and I can take a closer look.
Hey Bo, Thank you so much for your reply We mistakenly used approximately 10K in credit. https://app.clay.com/workspaces/600498/workbooks/wb_0sx819pAWMRHXiAEC8r/tables/t_0sx819pGvYSY9TURtfb/views/gv_0sws9jmPcBZuy6gob78 https://app.clay.com/workspaces/600498/workbooks/wb_0sx81jeVocVwcNRZN7Z/tables/t_0sx81jeX2WZ559fQsD4/views/gv_0sws9jmPcBZuy6gob78 https://app.clay.com/workspaces/600498/workbooks/wb_0sx2427svFMGQgp5KEX/tables/t_0sx2427tY29QtHWeqvd/views/gv_0sws9jmPcBZuy6gob78 https://app.clay.com/workspaces/600498/workbooks/wb_0sxfie3TE92Fwj7d45P/tables/t_0sxfie3ypTsioZktpih/views/gv_0sws9jmPcBZuy6gob78 https://app.clay.com/workspaces/600498/workbooks/wb_0sxdwt1V9XFVwoEjqQj/tables/t_0sxdwt1Yfqrdc8C3xzE/views/gv_0sws9jmPcBZuy6gob78 If you'd be so generous as to top this back up for us, we'll gladly follow your advice afterward. Thank you so much.
Hey, I’ve refunded the credits this time, but just a heads-up—we won’t be able to do that again going forward. You can check out this guide to help manage usage more effectively: Clay Credit Conservation Let me know if you have more questions.