Tfileinput loads incomplete data

Highlighted
Six Stars

Tfileinput loads incomplete data

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.


Accepted Solutions
Highlighted
Sixteen Stars
Sixteen Stars

Re: Tfileinput loads incomplete data

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


TRF

View solution in original post


All Replies
Highlighted
Nine Stars

Re: Tfileinput loads incomplete data

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

 

Regards,

Veeru Boppudi
Highlighted
Six Stars

Re: Tfileinput loads incomplete data

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?

 

6.png

 

Highlighted
Moderator

Re: Tfileinput loads incomplete data

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

Manohar B
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Sixteen Stars
Sixteen Stars

Re: Tfileinput loads incomplete data

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


TRF

View solution in original post

Highlighted
Moderator

Re: Tfileinput loads incomplete data

@KanT,still do you have this issue?

Manohar B
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Six Stars

Re: Tfileinput loads incomplete data

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog