Hi, I would know if exist a transformer that verify if file header is correct. Thanks
+17- Supporter
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?
+1- Contributor
itay wrote:
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.
+17- Supporter
maica wrote:
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
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.