Tfileinput loads incomplete data

[Anonymous]

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]

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

Regards,

[Anonymous]

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]

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

[TRF · Accepted solution]

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

[manodwhb]

@KanT,still do you have this issue?

[Anonymous]

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