topic Re: Another solution to solve this problem ? in Talend Studio

Another solution to solve this problem ?

jcpreaux — Wed, 11 Apr 2018 09:53:06 GMT

Hi The Community !

I've a job which purpose is to extract data from a database and to generate a file with these datas.

And as an extra, first and last lines must contain the numbers of extracted rows.

I've done a job which works well (see below) but is there another best solution to do this ?

Thanks !

JCP

Re: Another solution to solve this problem ?

TRF — Wed, 11 Apr 2018 10:12:00 GMT

Hi,

As you can't get the number of records before the select result, your solution is ok.

Maybe for the last line you should use a tFileRowCount (-1) to get the real nmber of lines in the output file (1rst line = expected number of records - last line = effective number of records).

Edit: I replaced "you get" by "you can't get" - of course!