Question

Write to single excel file from multiple sources

  • 12 December 2019
  • 2 replies
  • 6 views

Badge

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

Badge
For some reason I am not able to insert a screenshot.. I keep trying but receive an error message saying "Something Went Wrong".
Badge

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. :-)

Reply