Skip to main content

Hi, I would know if exist a transformer that verify if file header is correct. Thanks

Hi @maica,

Can you provide some more info? what kind of file/format? what is a 'correct' header? and can you provide a file to test?

 


Hi @maica,

Can you provide some more info? what kind of file/format? what is a 'correct' header? and can you provide a file to test?

 

Hi, the file is a simple csv that has a header. I would the ETL fails if the header change.


One way to validate a CSV header might be to use a dynamic CSV reader followed by a Tester to check for "Attribute is missing" on the attributes you expect to find in the CSV.


Hi, the file is a simple csv that has a header. I would the ETL fails if the header change.

You might want to have a look at the Schema (Any Format) reader. This reader returns the data model (schema) of your input as a list.

You can then compare this list to a list of expected attributes, something you can use the ListBasedFeatureMerger transformer for.


Reply