Skip to main content
Solved

Schema validation between two datasets


pinkopo
Contributor
Forum|alt.badge.img+5

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!

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

View original
Did this help you find an answer to your question?

6 replies

trentatsafe
Safer
Forum|alt.badge.img+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


stalknecht
Contributor
Forum|alt.badge.img+19
  • Contributor
  • Best Answer
  • August 7, 2017

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


pinkopo
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • August 16, 2017
trentatsafe wrote:

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!

 


takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • August 16, 2017
pinkopo wrote:
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).

 


pinkopo
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • August 16, 2017

Thanks guys!


pinkopo
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • August 16, 2017
takashi wrote:
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! ^.^

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings