Need to split the rows in multiples of 10

One Star

Need to split the rows in multiples of 10

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?
  
One Star

Re: Need to split the rows in multiples of 10

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
Moderator

Re: Need to split the rows in multiples of 10

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://www.talendforge.org/forum/viewtopic.php?id=44479
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Need to split the rows in multiples of 10

Thank you guys Smiley Happy
Moderator

Re: Need to split the rows in multiples of 10

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.