topic Re: [resolved] Extract sample rows from delimited input file in Talend Studio

[resolved] Extract sample rows from delimited input file

Anonymous — Tue, 31 Mar 2015 17:58:55 GMT

Hello
From one delimited input file (csv with X rows) I would like to extract a sample file with one row out of each 200.
Is there a component that will let me do this ?
If so, I think i'll have to get the number of line from input file with globalvar NBLINE, and add a modulus 200 (%200)
Thanks a lot.

Re: [resolved] Extract sample rows from delimited input file

Anonymous — Wed, 01 Apr 2015 08:17:00 GMT

Hi fbonnot,

Do you want to extract the first 200 rows or any 200 rows in input file? If former, you can use "Header", "Footer" and "Limit" option in tfileinputdelimited component to control the number of lines needed.
If you want to extract any 200 rows in your input file, could you please take a look at a related forum: https://community.talend.com/t5/Design-and-Development/resolved-how-to-read-data-from-text-file-from-nth-line-to-nth/td-p/111823 to see if it is what you are looking for?

Best regards
Sabrina

Re: [resolved] Extract sample rows from delimited input file

Anonymous — Wed, 01 Apr 2015 09:47:41 GMT

Do you need random rows then use Advance Setting--> "Extract Line at Random"
this can provide you random rows from your input file. use limit option to control the number of lines needed.

Re: [resolved] Extract sample rows from delimited input file

Anonymous — Thu, 02 Apr 2015 03:45:28 GMT

Hi
Thank you very much for your answers.
I needed a random output so I'll use the built in feature of the fileinputdelimited componant (lazy me ! could have found it alone)
Bye