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.
Page 1 / 1
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
Thanks, Takshi and Itay. Both methods gave me the same results.