Question

How to create a new spreadsheet for each group in a column

  • 14 January 2015
  • 2 replies
  • 0 views

Hi,

 

 

I was wondering if there is a way to create new spreadsheet for each group titled the same in the cell under a particular column? I have a dataset of over 1 million lines with various departments combined, and I need to find out a way to seperate them by department into new spreadsheets.

 

 

Any and all help would be appreciated.

2 replies

Userlevel 3
Badge +13
Hi,

 

 

Sounds like a job for a fanout on the xls writer, a writer feature type fanout will result in seperate sheets in a file, while a dataset fanout in different xls files.
Thanks. It did the trick!

Reply