+5Hi guys,
I am trying to find a way to get a list of matched and unmatched fields between two datasets.
The situation is our agency needs to reguarly download data from external sources and after download we need to check if there is any schema changes on the newly downloaded data.
Thank you!
Best answer by stalknecht
Hello @sangli,
You can read the schema's and use a changeDetector.
Follow the next link for some examples.
https://knowledge.safe.com/questions/1936/compare-2-schemas-get-list-of-new-attributes.html
Best regards,
Wilko Stalknecht
+6Hello @sangli,
This previous question may help answer your question. I believe it is a similar scenario that was asked.
https://knowledge.safe.com/questions/22533/how-to-detect-a-schema-difference-dataset1-has-x-a.html
+22Hello @sangli,
You can read the schema's and use a changeDetector.
Follow the next link for some examples.
https://knowledge.safe.com/questions/1936/compare-2-schemas-get-list-of-new-attributes.html
Best regards,
Wilko Stalknecht
+5Hello @sangli,
This previous question may help answer your question. I believe it is a similar scenario that was asked.
https://knowledge.safe.com/questions/22533/how-to-detect-a-schema-difference-dataset1-has-x-a.html
Both of the datasets that i want to compare are saved in file geodatabase, is there anyway the schema (any format) can read feature class from file geodatabase?
thanks!
Both of the datasets that i want to compare are saved in file geodatabase, is there anyway the schema (any format) can read feature class from file geodatabase?
thanks!
Or, drag and drop the *.gdb folder from Windows Explorer onto FME Workbench Canvas. The Add Reader dialog will open automatically with the *.gdb path. You can then change the Format field to the Schema (Any Format).
+5Or, drag and drop the *.gdb folder from Windows Explorer onto FME Workbench Canvas. The Add Reader dialog will open automatically with the *.gdb path. You can then change the Format field to the Schema (Any Format).
