Skip to main content
Question

Write to single excel file from multiple sources

  • December 12, 2019
  • 2 replies
  • 49 views

Forum|alt.badge.img+1

Hi, I am working on a project to identify attribute values that do not match for many SDE layers (26 total). I would like to write the results into separate sheets within the same excel file; however, I currently am only able to write one sheet at a time in the same excel file. I would appreciate some advice and suggestions!

2 replies

Forum|alt.badge.img+1
  • Author
  • December 12, 2019
For some reason I am not able to insert a screenshot.. I keep trying but receive an error message saying "Something Went Wrong".

Forum|alt.badge.img
  • December 12, 2019

Use a FeatureWriter. When you select Excel as format you will see that you can create multiple input ports to the transformer by dragging a connection to the "Connect Input" port. Each input port you create gives you an extra feature type when you open the parameters for the FeatureWriter and each feature type can be defined as a separate sheet in the excel file. This should do the trick for you. :-)


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