Skip to main content
Question

Read spreadsheet, group by attributes, then write to separate spreadsheets

  • January 24, 2020
  • 1 reply
  • 24 views

jmhomza
Contributor
Forum|alt.badge.img+1

Hi,

I have an Excel spreadsheet that has thousands of rows that need to be grouped together by a couple different columns, then write all grouped Features to their own individual spreadsheets. I've done this using the HTMLReportGenerator, then putting the HTML content table into an email, but I need to instead write each 'report' in a spreadsheet, so each table row would be an Excel row. Can anyone help with what transformers would be able to group the features without analyzing them, then write each grouping to their own respective fan-out spreadsheet?

1 reply

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • January 24, 2020

As you predicted, it is called Fanout.

It can be done by naming the writer feature type, like this:

Use the drop down arrow and then the Text Editor to create the Sheet Name.

Hope this helps.


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