How to reject the data via length and precision in Talend ?

[prabuj]

Hi Team,

For ex : Column ID , I am setting a length of 9 in tMap schema editor.

If the ID length is more than 9 from the input, I would like to reject those data and save it in a tlogrow.

If I set the length 9, in a column. Why data with 12 length can enter?

I know it can be handled with expression syntax, hopefully. But, why it couldn't be at schema editor level ?

Could you explain, am curious to know ? If can, please let me know how to do it ? (or) Please point out where am making a mistake to understand.

 

Thanks in advance.

[jlolling]

Did you tried the component tSchemaComplianceCheck. This component is dedicated to this task!

[jlolling]

The schema settings for length, precision and also pattern are never used inside a flow.

Length and precision is only used if theses values are needed like if you create a table or write into positional files or if you want to check these settings (the mentioned compliance check component).

Pattern only used in conversions of Date to String and String to Date like in some file input or output components (never in database components!) or in tLogRow.

[jlolling]

The component tSchemaComplianceCheck has a Reject flow or can die if the rules are violated.

[prabuj]

I will check on that. Thank you for the suggestion. I appreciate your effort towards it. !