Split output by row count

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.

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.

1 Like

Or you can use Filter.

1 Like

Brilliant, thanks for your quick reply.

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.

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