How can Get Error File

[Anonymous]

Hi Friends,

I would like to have an error file/table where I would like to see something like below
rec_key|record|error_code|error_msg
Ex:
1|a;shong|NUMERIC_CHECK_FAILED|id has a bad value "a"
6|f;Lee|NUMERIC_CHECK_FAILED|id has a bad value "f"
22|h;nike|NUMERIC_CHECK_FAILED|id has a bad value "h"

how can i do it?

Thanks for help

[Anonymous · Accepted solution]

Please checkout TSchemacompliencecheck component
https://help.talend.com/reader/QgrwjIQJDI2TJ1pa2caRQA/6vDIMZrg55gSAhjWnHb1hQ

[Anonymous]

Thank you So much