topic Re: Reject link in tFileinputExcel in Talend Studio

Reject link in tFileinputExcel

param123 — Wed, 06 Jun 2018 09:58:05 GMT

Hi,

Just trying to understand the exact use of Reject link for tFileinputExcel.

what should be the basic setup to get the rejected records and where to that setup in the component settings.

No matter what I do, I always get 0 records in reject link.

please advise with a practical scenario

thanks in advance!

Re: Reject link in tFileinputExcel

manodwhb — Wed, 06 Jun 2018 13:25:14 GMT

@rchinta,check the below link , that you will understand the rejection from Excel file.

https://www.datalytyx.com/informing-data-rejects-using-tmsgbox/

Re: Reject link in tFileinputExcel

param123 — Fri, 08 Jun 2018 08:07:46 GMT

@manodwhb

thanks for your response. i have seen the post before posting this query here, but even there it is connected to some other components to reject the data but there has been no explanation how the main and reject link will actually get the data.

will Talend automatically checks for junk data and pass that to reject link?

Re: Reject link in tFileinputExcel

Anonymous — Fri, 08 Jun 2018 08:22:48 GMT

Hello,

This reject row connection gathers the data that does NOT match the filter or are not valid for the expected output. This connection allows you to track the data that could not be processed for any reason (wrong type, undefined null value, etc.)

Best regards

Sabrina

Re: Reject link in tFileinputExcel

param123 — Sun, 10 Jun 2018 07:44:42 GMT

Hi xdshi,
Thanks for your response
So basically what you say is reject link captures the data anamolies.

So there is no need to setup anything??
And there is no way to check what exactly it is going to reject?

If possible can you please explain with an example data and screenshot?
Thanks in advance

Re: Reject link in tFileinputExcel

Anonymous — Thu, 21 Jun 2018 11:07:32 GMT

Hello,

You need set your column schema in tfileinputexcel with types, nullability, etc. In this way, this reject row connection will gather the data that is not valid for the expected output.

Here exists a component tschemaComplianceCheck which validates all input rows against a reference schema or check types, nullability, length of rows against reference values.

Best regards

Sabrina