I am working with volume data that runs to be in several million records and I was hoping to create an output that can be split into multiple files and each file consisting of that month.
Here is a simplified example of this:
Master File:
| Facility | Qty | Month |
| A | 1 | 4 |
| A | 67 | 5 |
| B | 45 | 4 |
| B | 1233 | 4 |
| B | 4332 | 5 |
| A | 23132 | 3 |
| A | 1 | 4 |
| B | 4 | 5 |
| B | 534 | 4 |
| A | 3213 | 3 |
| A | 34 | 5 |
| A | 8645 | 5 |
| B | 200 | 3 |
| B | 321 | 4 |
| B | 2131 | 4 |
| B | 23189 | 3 |
So this would be broke down into 3 files:
File 1:
| Facility | Qty | Month |
| A | 23132 | 3 |
| A | 3213 | 3 |
| B | 200 | 3 |
| B | 23189 | 3 |
File 2:
| Facility | Qty | Month |
| A | 1 | 4 |
| B | 45 | 4 |
| B | 1233 | 4 |
| A | 1 | 4 |
| B | 534 | 4 |
| B | 321 | 4 |
| B | 2131 | 4 |
File 3:
| Facility | Qty | Month |
| A | 67 | 5 |
| B | 4332 | 5 |
| B | 4 | 5 |
| A | 34 | 5 |
| A | 8645 | 5 |
Obviously this would be on a much larger scale, but wanted to see if anyone had any thoughts with how to approach this. Thank you!
