How to capture reject records

[Anonymous]

Am very new to Talend and am loading a salesforce object from a database table.

pretty simple job and it fails to load about 5% of the data.  I am just trying to capture the reject records to a xls or csv.  such an easy thing i imagine but cant seem to find where/how.

any help would be appreciated.

thanks!

[Anonymous]

Hi @ppp_rrr

please look at the screenshot I have attached below, I guess you exactly want the same job flow.

In the source, I'm having 5 records in which 2 records doesn't meet my condition so it gets rejected.

[Anonymous]

Hi @Sara,
thanks for the reply.

But when I'm trying it, it's not giving me the desired results. I am not applying any validation to the input data in tMap. Anything which is not accepted in Oracle database according to column type is rejected and should be stored in a separate excel file as a kind of report.
Please see my screeshot. you can see in console 3 rejected records, these should have gone to excel, but not so...

[Anonymous]

Hi @ppp_rrr

Please do the following  changes in your job and run

1.Uncheck "Die on error"

2.you will errorReject on your right-side just connect that to your tfileoutputexcel to see the rejected records and error message.