- Posts: 290
- Thank you received: 1
Custom Error Message Handling?
9 years 1 month ago #11125
by orlandoc
Custom Error Message Handling? was created by orlandoc
Hi,
I am trying to create a custom error message and save it to the database.
Imagine, I have a file with the following fields A, B, C, D and corresponding database table columns (A,B,C,D,Comment)
Fields A & B are mandatory so inside the Validator I am using 'Is Null' function to validate A & B field.
If A is null I would like to insert a string "Invalid field A" in the column 'Comment' section. I still want to audit the whole rows but in the comment field I have a custom message telling that a certain field is invalid.
How do I accomplish this inside the Transformation - Validator?
see screen-shot of the actual record in the database that I want it to be.
I am trying to create a custom error message and save it to the database.
Imagine, I have a file with the following fields A, B, C, D and corresponding database table columns (A,B,C,D,Comment)
Fields A & B are mandatory so inside the Validator I am using 'Is Null' function to validate A & B field.
If A is null I would like to insert a string "Invalid field A" in the column 'Comment' section. I still want to audit the whole rows but in the comment field I have a custom message telling that a certain field is invalid.
How do I accomplish this inside the Transformation - Validator?
see screen-shot of the actual record in the database that I want it to be.
Please Log in or Create an account to join the conversation.
9 years 1 month ago #11128
by admin
Mike
ETL Architect
Replied by admin on topic Custom Error Message Handling?
You can use "If functions2 for this kind of transformation
For complete data quality audit you can use log redirect, default repository has an example
Mike
For complete data quality audit you can use log redirect, default repository has an example
Mike
Mike
ETL Architect
The following user(s) said Thank You: orlandoc
Please Log in or Create an account to join the conversation.