How to capture column name or field name of rejected data

[muralam]

Hi,

I have a scenario like

​input data:

Col1 col2 col3

​Yes no yes

​yes No

​DEg yes yes

​Expected outcome:

FieldName Fieldvalue errormessage

​col2 Null or Empty

​col1. deg. Incorrect value

I am able to capture rejecte data from tmap but not able to capture FieldName of rejected data, I have to perform data quality checks on 10 columns as such all the 10 columns must contain yes or no other than Yes or no capture rejected data along with FieldName. Any help on this would be great

Thanks in advance​

[manodwhb]

@Meenakshi Murala​ ,check the tunipivot component may solve your issue. Which is custom competent

https://help.talend.com/r/9OYr_Es~kaz9Az26oKHOoQ/root

Thanks,

Manohar

[muralam]

No Manohar, this is not working as expected scenario while capturing rejected data I have to capture column name of the rejected value to table