Skip to main content
Question

write data to different Sheet

  • October 22, 2017
  • 6 replies
  • 153 views
boubcher
Contributor
Forum|alt.badge.img+11

we want to save data in one excel document but with multiples sheets, each one will have a specific group of features

please sheet the attached 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.

    6 replies

    takashi
    Celebrity
    • takashiCelebrity
    • October 22, 2017

    Hi @boubcher, if you set the fme_feature_type_name attribute to the Sheet Name field in the Excel writer feature type, each feature will be written into a sheet whose name is the same as the attribute value. See also here: Setting Feature Type Fanout

    Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
    boubcher
    Contributor
    Forum|alt.badge.img+11
    • boubcherContributor
    • Author
    • Contributor
    • October 22, 2017

    Hello Takashi

    Thanks its now creating sheet for every data group, but I have no idea why it's duplicating the data ,I trayed o play multiple combinations with Feature type Dialogue but with no result

    Any idea

    save-to-diffrent-sheet2.png

    redgeographics
    VIP
    Forum|alt.badge.img+63

    Hello Takashi

    Thanks its now creating sheet for every data group, but I have no idea why it's duplicating the data ,I trayed o play multiple combinations with Feature type Dialogue but with no result

    Any idea

    save-to-diffrent-sheet2.png

    If you check the writer parameters in the Navigator there's one, for Excel, that says "Overwrite existing file", it's set to "No" by default which means each time you run the workspace it appends the results to the file, rather than writing a new copy.

     

     

    FME rocks! \m/
    boubcher
    Contributor
    Forum|alt.badge.img+11
    • boubcherContributor
    • Author
    • Contributor
    • October 23, 2017

    Thanks ,

    We did set the overwrite option to yes, but still, we are getting the data duplicated (exactly 4 times)

    No idea how this possible?

    Attached the work space

    extact-transportation-schema.fmw

    takashi
    Celebrity
    • takashiCelebrity
    • October 23, 2017

    Thanks ,

    We did set the overwrite option to yes, but still, we are getting the data duplicated (exactly 4 times)

    No idea how this possible?

    Attached the work space

    extact-transportation-schema.fmw

    You have removed "TransportationZone**/" (** = 36, 37, 38, 39) from the values of "fme_feature_type_name". If there were "TransportationZone36/BusStation" and "TransportationZone37/BusStation" originally, naturally "BusStation" would get duplicated after translation.

     

     

    Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
    boubcher
    Contributor
    Forum|alt.badge.img+11
    • boubcherContributor
    • Author
    • Contributor
    • October 24, 2017

    Thanks TAKASHI , no idea how we missed that

    :)

    Community Stats

    32,763
    Posts
    124,242
    Replies
    41,288
    Members
    Terms & ConditionsAccessibility 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.