which is the best way to split records in a table? lets say I have 1,000 records in a table, I want to divide it into chunks of 200 each, which is the best trick to do that?
use case: distribute leads across different users
๐ 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 Esteban, how's it going? Good one. I'd say one of the easiest ways to split them up, if it's within the same table, you can create separate views and apply row filter limits as shown below. Otherwise, if you're looking to push them to separate tables, I'd probably go with a CSV that I'd split in batches or running write to tables also in batches, but these do seem to require a few more steps. Hope that helps! https://downloads.intercomcdn.com/i/o/1174527614/231c53a2c38d292e8da3de1d/image.png?expires=1725931800&signature=4daa44e6bfe6acdfd6c2079cd09b4499ab834fb147c9e715b5e3fcf2e1731887&req=dSEgEsx8modeXfMW1HO4zZDVRhHbBOYG6t6hhaTKC5UOwwfgVHGToBtsvsp6%0AkGm0%0A
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!
Hi Esteban L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: