split target csv file into more smaller CSV's

[SL12345]

Hi Snaplogic experts, 

my pipeline is creating one big CSV file (50k rows) as the result. Collegues asked me, if it is possible to split this big CSV file into smaller ones (create csv files with thousand rows)

My question is, how to make  more csv files as an output ? 

my idea is: 
get number of all  rows for output,  using Math.floor function  get how many iterations are needed and then make a loop in order to split rows into  csv files first file - row  1 - 1000 second file 1001 - 2000 and so on .... 

or is there another better approach? 

Thank you

[alchemiz]

Hi @SL12345 

See attached, hope this helps.

Assumption CSV file exits and is delimited by CR+LF 

~alchemiz

[alchemiz]

CSV is row delimited by CR+LF