is it possible to capture column name for a rejected records and which talend component are suitable to use for it?
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?
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
|ID | |column name |
|1829| |receive_date |
|1830 | | department,FI_CODE|
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.
Are you able to connect the tMap component to tFileOutputDelimited or t<DB>Output component by using the 'Row' connection?
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.
Please feel free to accept the solution if it is OK with you quesion.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema