Skip to main content
Solved

Split spreadsheet based on a column

  • November 4, 2021
  • 2 replies
  • 167 views
R
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

    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.

    2 replies

    ebygomm
    Influencer
    Forum|alt.badge.img+44
    • ebygommInfluencer
    • Influencer
    • 3422 replies
    • Best Answer
    • November 4, 2021

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

    image

    R
    Forum|alt.badge.img
    • rob_nason
    • Author
    • 14 replies
    • November 4, 2021

    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.

    Community Stats

    32,061
    Posts
    121,725
    Replies
    39,688
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.