Question

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

Forum|Forum|11 years ago
January 14, 2015
2 replies
40 views

dlajola

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

+22

fmelizard
Safer
Forum|Forum|11 years ago
January 14, 2015

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.