topic Re: Tfileinput loads incomplete data in Talend Studio

Tfileinput loads incomplete data

Anonymous — Sat, 14 Apr 2018 19:13:17 GMT

HI,

I have a table that has 8000 rows. When I output this table to Tfileoutput, it loads only 7500 rows.

is there any reason why it is loading only 7500 and missing 500 rows? is there a setting that I checked accidently. pls let me know.

vboppudi — Sun, 15 Apr 2018 15:45:03 GMT

If possible please provide screen shot of job. Have you implemented any logic in job?

Regards,

Anonymous — Sun, 15 Apr 2018 21:51:25 GMT

There is no logic build in tmap.

My input file has 8263 rows but it shows 7290 rows in output. See the screenshot. What could be a possible cause for it?

manodwhb — Mon, 16 Apr 2018 11:28:29 GMT

yes.it could be possiable with bad data.can you get reject to log/file from tFileinput.

TRF — Mon, 16 Apr 2018 14:49:24 GMT

Connect the tInputFileDelimited to a tOutputFileDelimited using a Reject flow to get the rejected records (those not respecting the defined schema).

manodwhb — Thu, 19 Apr 2018 06:16:50 GMT

@KanT,still do you have this issue?

Anonymous — Thu, 19 Apr 2018 17:51:49 GMT

Hi, I was able to solve the issue.Thanks for checking!