Compare schema (xlsx) to another xlsx populated with field data and verify records are correct

Hi @jackofallcad

I think the transformer AttributeValidator is important in your case to validade the type os attributes:

AttributeValidator

Thanks,

Danilo

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