topic Need to split the rows in multiples of 10 in Talend Studio

Need to split the rows in multiples of 10

Anonymous — Wed, 25 Nov 2015 12:40:59 GMT

I have 100 rows and i want to split the rows in multiple of 10
The First 10 rows should have one target and second 10 rows should have another target and so on...
Do we have any component for this?

Re: Need to split the rows in multiples of 10

Anonymous — Wed, 25 Nov 2015 13:21:22 GMT

I have 100 rows and i want to split the rows in multiple of 10
The First 10 rows should have one target and second 10 rows should have another target and so on...
Do we have any component for this?

Hi,
Add a new sequence column ( Numeric.sequence("mysequence",1,1) from 1 to 100 in your schema and filter your output folowing this sequence

Re: Need to split the rows in multiples of 10

Anonymous — Thu, 26 Nov 2015 04:11:00 GMT

Hi,
Here is "Split output in several files" option in tfileoutputdelimited component which divide the output delimited file into several files.
You can set the number of lines in each of the output files by using "Rows in each output file".
Here is a related forum: https://community.talend.com/t5/Design-and-Development/split-a-file-in-several-rows/td-p/98452
Best regards
Sabrina

Re: Need to split the rows in multiples of 10

Anonymous — Mon, 30 Nov 2015 08:07:02 GMT

Thank you guys

Re: Need to split the rows in multiples of 10

Anonymous — Mon, 30 Nov 2015 08:16:50 GMT

Hi,
Can we consider this topic as resolved? Feel free to let us know if there is any further help we can give.
Best regards
Sabrina