topic Re: How to capture rejected records . in Talend Studio

How to capture rejected records .

Anonymous — Tue, 12 Jul 2016 19:17:31 GMT

Hi All,
As per my business need I need to capture from the Inputfile tfileinputExcel -- > actual(correct ) records along with count and rejected records along with count .
I tried using Main link and rejected link of tfileinputexcel component but ( rejected link is not capturing all rejected data , its only capturing rejected column information .
For ex :In my input If I have 5 column and If First column has error records in the error message its only giving information about 1st column , rest all blank . and if we have error in 3 rd column first two column information and error record information it is showing 4 and 5 getting displayed has null and so on .

BUt My requirement is capture all the error record along with count and send the file back to client for there confirmation and reprocess it .

Please help me how can I implement this logic
I need to caputure all the column (row information) information along with count .
thanks
Mohini

Re: How to capture rejected records .

Anonymous — Wed, 13 Jul 2016 03:19:11 GMT

Hi,
Here is a component TalendHelpCenter:tSchemaComplianceCheck which is used to check types, nullability, length of rows against reference values.
Best regards
Sabrina

Re: How to capture rejected records .

Anonymous — Wed, 13 Jul 2016 06:39:04 GMT

thanks Sabrina ,

But requirement is I need to reject it from the source input itself ..my input is tinputfileExcel from there only I have to pass two links one is target orther one is reject .
reject link is not giving all the records ( meaning if I have 5 records in my input I need all the 5 records in my rejected file ) but now if have error in first records .. reject file is giving all "null" for those record and along with message "5jee" is integer but it has string in it .
So kindly help ..

Re: How to capture rejected records .

Anonymous — Wed, 13 Jul 2016 07:36:37 GMT

Main out put

=====================

| tLogRow_1 |

|=----+--+---=|

|Name |id|sal |

|=----+--+---=|

|meena|2 |6000|

|sona |3 |400 |

'-----+--+----'

.----+--+---+-----Rejected----+----------------------------------.

| tLogRow_2 |

|=---+--+---+---------+---------------------------------=|

|Name|id|sal|errorCode|errorMessage |

|=---+--+---+---------+---------------------------------=|

|mona| null|null|null |For input string: "1SSS" - Line: 0|

I need records instead of null

'----+--+---+---------+----------------------------------'

Re: How to capture rejected records .

Anonymous — Thu, 14 Jul 2016 10:42:01 GMT

Hi,
What does your input look like? How did you set tschemacompliancecheck? Screenshots of job setting will be preferred.
Best regards
Sabrina