topic Re: Capture rejected data with column nam in Talend Studio

Capture rejected data with column nam

Anonymous — Tue, 31 Jul 2018 08:04:37 GMT

hi guys

is it possible to capture column name for a rejected records and which talend component are suitable to use for it?

Re: Capture rejected data with column nam

Anonymous — Tue, 31 Jul 2018 08:21:22 GMT

Hello,

Could you please set an example for your use case? It makes more easy to understand - where the problem.

Are you using talend data quality or data integration product?

Best regards

Sabrina

Re: Capture rejected data with column nam

Anonymous — Tue, 31 Jul 2018 08:54:39 GMT

I am doing record matching from multiple sources. so, if I've 50 columns to match/compare then i need talend just throw error or capture only for the column that the record is not match, so it will be easier to acknowledge the problem column. i am using talend data integration

---------------------------------

example output:

|ID | |column name |

|1829| |receive_date |

|1830 | | department,FI_CODE|

Re: Capture rejected data with column nam

Anonymous — Tue, 31 Jul 2018 09:20:09 GMT

Hello,

Could you please have a look at tMap component to see if it is what are you looking for?

In the tMap settings, here exists 'Catch lookup inner join' option(set it as true) which can handle rejects.

Please refer to the scenario about:TalendHelpCenter:Mapping with join output tables.

Best regards

Sabrina

Re: Capture rejected data with column nam

Anonymous — Tue, 31 Jul 2018 09:44:17 GMT

yes.. I've already done that. for the next step, how can i print out the mismatch column name into textfile or table

Re: Capture rejected data with column nam

Anonymous — Tue, 31 Jul 2018 09:55:06 GMT

Hello,

Are you able to connect the tMap component to tFileOutputDelimited or t<DB>Output component by using the 'Row' connection?

Best regards

Sabrina

Re: Capture rejected data with column nam

Anonymous — Tue, 31 Jul 2018 10:19:52 GMT

yes... what you mean by 'row' connection?

Re: Capture rejected data with column nam

Anonymous — Tue, 31 Jul 2018 10:46:11 GMT

Hello,

It is Row connection. There are various types of connections which define either the data to be processed, the data output, or the Job logical sequence.

For more information, please have a look at this online document about:TalendHelpCenter:Connection types

Hope it will be helpful for your further processing. Don't hesitate to post your issue here.

Best regards

Sabrina

Re: Capture rejected data with column nam

Anonymous — Wed, 01 Aug 2018 03:51:11 GMT

Hello,

Please feel free to accept the solution if it is OK with you quesion.

Best regards

Sabrina