Flat File Validation at a Structure Level

[steynie8]

Is it possible to perform validation on a flat file from a structure level, and if so, how do you go about doing it?

I have tried reading in the file using a tFileInputPositional and then using a tSchemaComplianceCheck component to validate the columns but when it comes time to use the data mapper, the tHMap component expects a flow with a single column for incoming data.

I would like some elements in the structure to be mandatory.  If there is no value for that element (i.e. an empty space for the length of the element), I want to throw an exception.

See the example below:

DataB does not contain a value but is mandatory element.  It should therefore fail.  I understand that regardless of whether DataB has a value or not, Talend will see a value for that element ('dataBBB' if there is a value or 7 spaces if there is not a value). 

I have tried making use of the several functions in the Validate tab on the structure but I am unable to get the desired result.

Thank you for your assistance.

[Anonymous]

Hello,

What does your expected output look like? The hierarchy is degenerate and can be represented by a single flat file.

Best regards

Sabrina