Skip to main content
  • EN
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.
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


Community Stats

30,108
Posts
114,295
Replies
37,744
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.