I have a data row with thounsand columns, I 'm checking if each column have right data by tSchemaComplianceCheck (check length and data type).
Now I want to export if any column have error data. Some informations i want to export are:
+ value of key column
+ the name of error column
+ the error data
+ the error message, if a column have more than one error(invalid length and datatype), the error messages are sepatated with comma.
Each error column is exported to one row.
Can you give me some solution ?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables