+3Hi, What is the best way to manage the schema drifting issue?
Context: Currently the user uploads an Excel File through Workspace apps, and the file contains multiple attributes where the attribute names can change anytime. ID can be reported as Id, Identifier, id, ID.
What is the best way to map and standardize these attributes ?
+19Hi
Thank you for posting your question on the FME Community!
If your workflow expects a defined output schema and uploaded Excel files need to conform to it, the SchemaMapper transformer is a great approach.
You can create an external lookup table (for example, a CSV file) that maps variations of attribute names to standardized names (e.g., ID, Id, Identifier → id). SchemaMapper will then automatically rename incoming attributes to match your target schema.
These resources provide helpful guidance on setting it up:
Hope this helps!
