I have multiple feature classes that are in one geodatabase. I want to merge (append) these feature classes over a given schema to a separate file geodatabase. What transformer do I use?
Question
Merge multiple ESRI feature classes with same output shema
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+26- Contributor
No transformers needed. Just connect the input features classes to the output feature class and run the workspace.
No transformers needed. Just connect the input features classes to the output feature class and run the workspace.
When I do that it runs successfully if there is only one feature class in the output geodatabase. But once I bring in a second one it throws a bunch of "bad value" errors
+26- Contributor
If the output has the same schema, you should not even have to read the data twice. Just point the input feature types to both output feature types. Like this:
And connect both output feature types.
The bad value indicates a different schema (data types) for the second output.
+10- Contributor
Are you trying to replicate the original gdb or insert all the feature classes into 1 featureclass in your new gdb? If you want them all in one feature class @as erik_jan said above the error indicates different schemas so it can not merge them into one in that way.
If you want to write them out into separate feature classes in the same gdb highlight your reader and select duplicate on writer. If you are trying to push them all into one feature class they would need to be the same geometries and schema as the first.
Are you trying to replicate the original gdb or insert all the feature classes into 1 featureclass in your new gdb? If you want them all in one feature class @as erik_jan said above the error indicates different schemas so it can not merge them into one in that way.
If you want to write them out into separate feature classes in the same gdb highlight your reader and select duplicate on writer. If you are trying to push them all into one feature class they would need to be the same geometries and schema as the first.
I am trying to insert all the feature classes (merged over all the separate states as seen above ca_, co_, nm_, etc) and then output to a new gdb. I want the output feature classes to have the correct schema and if the schema doesnt match, me to be alerted.
+10- Contributor
I am trying to insert all the feature classes (merged over all the separate states as seen above ca_, co_, nm_, etc) and then output to a new gdb. I want the output feature classes to have the correct schema and if the schema doesnt match, me to be alerted.
Then I think you are getting the message about bad value because the datatype in the Writer allows for less characters then there are in the Reader featureclass or maybe one of the datatypes doesn't match what is expected in the reader. Maybe look at just increasing the characters on your writer first so it doesn't reject the data . You could use the attribute Validator if you needed to test your attributes. I'd try doing the above before I tackled any more complicated schema mapping as it looks from your comment above that these datasets should be pretty similar.
If your feature classes are in fact quite different you might want to check out the schemamapper or attributemanager to start mapping your featureclasses.
https://knowledge.safe.com/articles/1136/schemamapper-transformer-tutorial.html
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.