I am brand new to FME. I have a schema that i need to compare field collected data to to verify that all the attributes are there and are valid data types.
Schema:
XSLX of field data:
Thanks! John
Question
Compare schema (xlsx) to another xlsx populated with field data and verify records are correct
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+51- Celebrity
- 2077 replies
Hi @jackofallcad
I think the transformer AttributeValidator is important in your case to validade the type os attributes:
Thanks,
Danilo
- 7843 replies
Could you please specifically explain about required validation rules for each data type?
@jackofallcad the most straight forward solution is to add your rules to the AttirbuteValidator as @danilo_fme suggested. But AttributeValidator is a bit tedious to use if you have many rules, or if rules change. An alternative is to use the DatabaseJoiner as a lookup to your schema spreadsheet. With a very little restructuring, your schema spreadsheet could be used for this. Your domain values would need to be in a single field on the same line as the attribute name.
There are some ideas on using the DatabaseJoiner to validate schemas in the webinar 'Data Validation Victories', particularly the ideas from City of Kitchener / Consortech (starting about slide 20) . A bit more detail in the full presentation