Skip to main content
Question

How to duplicate the geometry for duplicated matches in FeatureMerger?


aguan
Contributor
Forum|alt.badge.img+11
  • Contributor
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.

3 replies

fmelizard
Safer
Forum|alt.badge.img+18
  • Safer
  • December 9, 2013
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

takashi
Influencer
  • December 10, 2013
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

aguan
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • January 3, 2014
Thanks, Takshi and Itay. Both methods gave me the same results.

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