Question

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

  • 24 January 2020
  • 1 reply
  • 4 views
jmhomza
Rank
Badge

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
Rank
Userlevel 2
Badge +16

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.

Reply


Community Stats

28,681
Posts
109,408
Replies
36,542
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.