Flat File Validation at a Structure Level

steynie8 — Tue, 04 Jun 2019 14:32:46 GMT

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.

Re: Flat File Validation at a Structure Level

Anonymous — Mon, 01 Jul 2019 08:00:09 GMT

Hello,

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

Best regards

Sabrina

topic Re: Flat File Validation at a Structure Level in Talend Studio

Flat File Validation at a Structure Level

Re: Flat File Validation at a Structure Level