Split output by row count

Question
1

Is it possible to split the output of a file by row count? I need to split the file I’m transforming to a max of 1 million rows per output file.
Thanks

2

You can use a Row Num transform to number the rows and then a Slice transform chop it into sections. The attached image shows chopping a file into 5k row sections.

slice
slice2652×1006 210 KB

1 Like
3

Or you can use Filter.

filters
filters2610×1048 228 KB

1 Like
4

Brilliant, thanks for your quick reply.

5

Is it possible to add a screenshot of the 2nd slice and/or filter settings? My 2nd box is currently returning 0 rows and I can’t quite figure out why. Thanks.

6

I have deleted the example. But in my example the second filter was set:
Matching all
Row Num >= 5001
Row Num <= 10000