Skip to main content
Solved

Split spreadsheet based on a column

  • November 4, 2021
  • 2 replies
  • 125 views

Forum|alt.badge.img

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?

Best answer by ebygomm

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

image

View original
Did this help you find an answer to your question?

2 replies

ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • Best Answer
  • November 4, 2021

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

image


Forum|alt.badge.img
  • Author
  • November 4, 2021
ebygomm wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings