Skip to main content
Solved

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.


cshir065
Forum|alt.badge.img

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

Best answer by debbiatsafe

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?

View original
Did this help you find an answer to your question?

2 replies

debbiatsafe
Safer
Forum|alt.badge.img+20
  • Safer
  • Best Answer
  • August 25, 2020

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
Forum|alt.badge.img
  • Author
  • August 26, 2020
debbiatsafe wrote:

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' 👍


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