Skip to main content

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