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

Five Stars

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

 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

Forteen Stars TRF
Forteen Stars

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

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.

TRF