topic Re: How to store error occurring data in Talend Studio

How to store error occurring data

Anonymous — Sat, 16 Nov 2024 03:43:10 GMT

Hi,

Now am reading .xlsx file and stored to the table, but some rows are occurring the error and data will be stored on the target table, for example the total number of rows is 110, but inside a table is only 105 rows are stored on tDBOutput1 and I want to store failed records also in a separate table on tDBOutput2.

Please, anyone, help me.

Re: How to store error occurring data

Anonymous — Sun, 29 Dec 2019 02:35:29 GMT

Hi
There is an reject flow on tDBOutput, the problematical records will be captured and stored in reject flow during the execution. eg:
...tDBOutput1--reject--tlogRow(or tDBOutput2)
Note that the reject flow is only available when 'Die on error' box and 'Extend insert' (Batch insert) box is unchecked.

Regards
Shong