Append to SDE from joined Excel spreadsheets and address point feature class not working properly. It's only appending the attributes and not appending the geometry.

Question

Hello,

I wrote a tool to join 3 Excel spreadsheets (solar data and 2 different meter tables) and an address point feature class. I tried appending this data to a SDE geodatabase feature class called, Distributed Generation. The writer only appended the attributes and not the geometry. I'm not sure why the geometry is getting lost during the translation. (As a temporary work around... i wrote it to a file geodatabase and am manually appending in ArcMap).

I have attached a screenshot of my workflow and parameters of the writer. Any help or ideas would be greatly appreciated 😊

SolarExportHelp2

SolarExportHelp1

debbiatsafe · Accepted Answer

I would recommend double-checking the FeatureJoiner transformers, FeatureJoiner_3 in particular.

The address point feature class is connected to the Right input port. Is the Geometry Handling parameter set to 'Use Right' in FeatureJoiner_3?

cshir065 · Answer

I would recommend double-checking the FeatureJoiner transformers, FeatureJoiner_3 in particular.

The address point feature class is connected to the Right input port. Is the Geometry Handling parameter set to 'Use Right' in FeatureJoiner_3?

@debbiatsafe Thank you so much... that solved the problem. I had missed that detail in 'FeatureJoiner_3' 👍

Append to SDE from joined Excel spreadsheets and address point feature class not working properly. It's only appending the attributes and not appending the geometry.

2 replies

Community Stats

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute