Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
steynie8
Contributor
Contributor

Flat File Validation at a Structure Level

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:

0683p000009M58X.png

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.

 

Labels (2)
1 Reply
Anonymous
Not applicable

Hello,

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

Best regards

Sabrina