Skip to main content
  • EN

Each month I have a spreadsheet I would like to split into several separate spreadsheets based on values in one of the columns. This column contains peoples names and I would like a spreadsheet per person to be written out.

 

To complicate matters the values in the name column can change each month so the process would need to be dynamic.

 

How would you achieve this in FME?

You would just need to fanout on the writer on the persons name

image

You would just need to fanout on the writer on the persons name

image

That's perfect thank you. The first time I tried it the only thing I didn't do was include the file format at the end of the statement @Value(Name).xlsx.

Reply


Community Stats

30,168
Posts
114,527
Replies
37,825
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.