Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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?
  
Labels (2)
4 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

Thank you guys 0683p000009MACn.png
Anonymous
Not applicable
Author

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