topic How to capture reject from tMysqlInput component due to mismatch in datatype in Talend Studio

How to capture reject from tMysqlInput component due to mismatch in datatype

Anonymous — Fri, 23 Mar 2018 06:09:19 GMT

Hi All,

I'm not able to fetch the reject records separately which is causing my job to die,

I'm Passing a query to tmysqlinput and defined schema but data with mismatch datatype is causing job to die in the middle, i.e column define as float in schema but in the flow same column is of string data type for one row , I want to fetch that row separately without dieing my Job. Please help

Re: How to capture reject from tMysqlInput component due to mismatch in datatype

TRF — Fri, 23 Mar 2018 06:20:37 GMT

Hi,
Your schema definition must match with the datatype of each result column.
So you have to define this specific column as string then, depending of it's value, convert it to float or apply the process you want.
If you just want to exclude the concerned rows from your dataset, apply the required where clause in your select.