splitting output records in half

[kas]

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

[binuacs · Accepted solution]

@kas  Tile Tool would be helpful for this scenario and the Time Number will give you the two part

[Luke_C]

Hi @kas 

I agree with @binuacs. Use the tile tool to get however many groups you need, then you can use those groups to come up with unique file names to generate separate outputs. Depending on your format (csv, xlsx, etc) the configurations would vary:

[kas]

@binuacs - Simple solution and worked perfectly, thank you!

Kim