SOLVED
splitting output records in half
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
kas
8 - Asteroid
‎01-07-2022
11:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I've seen several different scenarios about splitting records, but none that I can adapt for my scenario.
I just need to simply split my final output into to two equal, or close if odd number of rows, files. Once split they get assigned to two different associates, therefore the need to split. The count of rows will change each month so I can't use a set number to split them.
One month there may be 274 rows, the next 315 etc. One further catch is they can't be random but must remain in the consecutive order they are in before the split.
Mock sample below if that helps.
Plan Date | Plan # | Agency | CoCode | Policy Number |
2020-01-01 | 185 | 049 | 100 | 1234567 |
2020-01-01 | 139A | 072 | 100 | 1234568 |
2020-01-01 | 275 | 008 | 100 | 1234569 |
2020-01-01 | 234 | 038 | 100 | 1234570 |
2020-01-01 | 957 | 041 | 100 | 1234571 |
2020-01-01 | 309 | 041 | 100 | 1234572 |
2020-01-01 | 407 | 101 | 100 | 1234573 |
2020-01-01 | 4046 | 043 | 100 | 1234574 |
2020-01-01 | 4679 | 041 | 100 | 1234575 |
Thanks in advance,
Kim
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
3 REPLIES 3
binuacs
21 - Polaris
‎01-07-2022
12:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎01-07-2022
01:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-07-2022
01:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
