Skip to main content
Question

write data to different Sheet

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

    6 replies

    takashi
    Influencer
    • takashiInfluencer
    • 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

    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
    Celebrity
    Forum|alt.badge.img+49
    boubcher wrote:

    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.

     

     

    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
    Influencer
    • takashiInfluencer
    • October 23, 2017
    boubcher wrote:

    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.

     

     

    boubcher
    Contributor
    Forum|alt.badge.img+11
    • boubcherContributor
    • Author
    • Contributor
    • October 24, 2017

    Thanks TAKASHI , no idea how we missed that

    :)

    Reply


    Helpful Members This Week

    Community Stats

    31,201
    Posts
    118,277
    Replies
    38,804
    Members

    Latest FME

    Terms & ConditionsCookie settings

    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
    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.