topic Re: Capture rejected record's column in Talend Studio

Capture rejected record's column

Anonymous — Fri, 09 Jun 2017 12:10:28 GMT

I am trying to capture rejected rows in an excle file.... But although it is rejecting the records correctly..but in output it is still showing 0 records. Why so? can you please help?

Re: Capture rejected record's column

TRF — Fri, 09 Jun 2017 22:01:45 GMT

1st, rejected records don't go to an Excel file, but to a csv file. Also, on the capture you can see there is no rejected record (green 0 rows on top of the reject flow).
So, except the file you are looking for, the situation seems normal.
What do you expect?

Re: Capture rejected record's column

Anonymous — Mon, 12 Jun 2017 05:57:15 GMT

The situation is that I have 10 records, out of which 7 are OK and 3 i am expecting to go as rejected records and they should be stored in a separate excel as I am trying. On the console it shows me the error records like 'Invalid date' etc. but why these erroneous records do not go in the excel?

Re: Capture rejected record's column

Anonymous — Mon, 12 Jun 2017 09:51:11 GMT

Any inputs on this?

I want these rows in console to be directed to the excel so as to generate a kind of report...

Re: Capture rejected record's column

cterenzi — Mon, 12 Jun 2017 15:10:42 GMT

Those messages are likely generated by tFileInputDelimited. I think you can get a reject flow from there. (right-click -> row -> Reject)

Re: Capture rejected record's column

Anonymous — Tue, 13 Jun 2017 10:01:20 GMT

Ya thanks it worked!

Re: Capture rejected record's column

Anonymous — Fri, 16 Jun 2017 08:42:20 GMT

Going forward, one of my client's requirement is that they should be able to visually see all the changes or 'fix' that was applied to data during transformation so that they can 'Commit' or Rollback.

Will that be possible?

Also please give me a good example of Commit and Rollback in Talend.

Regards

Pankaj

@ppp_rrr wrote:

Ya thanks it worked!