Solved

Split spreadsheet based on a column

  • 4 November 2021
  • 2 replies
  • 15 views

Badge

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?

icon

Best answer by ebygomm 4 November 2021, 15:44

View original

2 replies

Userlevel 1
Badge +21

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

image

Badge

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