Question
How to duplicate the geometry for duplicated matches in FeatureMerger?
+11- Supporter
I Have a sde feature class and an excel spreadsheet. I want to create a new feature class using the sde feature class and some of the attribues in the spreadsheet. The spreadsheet has many-to-one relationship to the sde feature class and I want to duplicate the geometry for all matched duplicates. Look like I can't do it in the FeatureMerger with the sde as the requestor and the spreadsheet as the supplier. Any advice how to do this? I can achieve this with loading the spreadsheet into an Oracle table and create a sde view, but that is not what I prefer.
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.
+22- Safer
Hi,
You can use the sde as the requestor and the xls as supplier, make sure that you are giving the supplier list a name (Mylist) and use the List Exploder to recreate the sde geometries with xls attributes.
Itay
Hi,
Yes, you can do it with the FeatureMerger.
I think Itay's way (SDE --> REQUESTOR, XLS --> SUPPLIER, Process Duplicate Suppliers: yes, specify list name, use a ListExploder) is general.
There could be another usage in this case. Send XLS features to REQUESTOR, send SDE features to SUPPLIER, and select "Attributes and Geometry" as Feature Merge Type parameter. Then, the FeatureMerger appends attributes and geometry of a supplier (SDE feature) to all matched requesters (XLS records).
Takashi
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.