Solved

Schema validation between two datasets

  • 7 August 2017
  • 6 replies
  • 35 views

Badge

Hi 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!

icon

Best answer by stalknecht 7 August 2017, 10:47

View original

6 replies

Badge +6

Hello @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

Userlevel 1
Badge +18

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

Badge

Hello @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

Thanks @trentatsafe

 

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!

 

Userlevel 2
Badge +17
Thanks @trentatsafe

 

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!

 

No problem. You can just enter manually the *.gdb path to the Dataset field of the Add Reader dialog.

 

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).

 

Badge

Thanks guys!

Badge
No problem. You can just enter manually the *.gdb path to the Dataset field of the Add Reader dialog.

 

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).

 

Great thank you takashi san you are the best! ^.^

 

 

Reply