Skip to main content
Solved

insert new feature

  • May 31, 2016
  • 5 replies
  • 21 views
boubcher
Contributor
Forum|alt.badge.img+11

Hello Guys

I have an excel sheet with a total of school in each district we want to create a new sheet where we give each school name sch1, sch2 ... incrementally the total will represent the the Total school in sheet one , the number f classes will be divided equally to the number of school , then input is in total school sheet and the out put we are looking for is in the School Name sheet , we are doing this in order to give each school its reel location and after each school will update their information.

Thanks

Best answer by takashi

Hi, this is a fundamental way in the case where the remainder can be discarded.

  1. ExpressionEvaluator: Calculate the average of student number for each district. The @int function truncates decimal places.
  2. Cloner: Create copies of features for each district by the number of schools.
  3. ExpressionEvaluator_2: Increment the copy number attribute if necessary.
  4. StringConcatenator: Concatenate "sch", value of "Dist", and the copy number to create school name.

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

    5 replies

    takashi
    Celebrity
    • takashiCelebrity
    • May 31, 2016

    Hi @boubcher, if the total number of students cannot be divided by the number of schools, how should the remainder be distributed to the schools?

    It would be easy if the remainder can be discarded (e.g. District B 67 -> 33 and 33 for two schools, discard the remainder 1). However, if the remainder cannot be discarded, the solution would be different according to how to distribute the remainder to the schools and you need to define the rule for distribution strictly.

    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
    • June 6, 2016

    Thanks Takashi

    you are are right we can set the value to the remainder. , how could create those features it didnt work for me

    takashi
    Celebrity
    • takashiCelebrity
    • Best Answer
    • June 6, 2016

    Hi, this is a fundamental way in the case where the remainder can be discarded.

    1. ExpressionEvaluator: Calculate the average of student number for each district. The @int function truncates decimal places.
    2. Cloner: Create copies of features for each district by the number of schools.
    3. ExpressionEvaluator_2: Increment the copy number attribute if necessary.
    4. StringConcatenator: Concatenate "sch", value of "Dist", and the copy number to create school name.

    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
    • June 7, 2016

    Thanks Takashi work fine ,

    boubcher
    Contributor
    Forum|alt.badge.img+11
    • boubcherContributor
    • Author
    • Contributor
    • June 7, 2016

    I resolve the problem in case there is a remainder between to Global total of the district and when we break down based on shcooleinsert-new-featur.fmwt

    Community Stats

    32,154
    Posts
    122,047
    Replies
    39,812
    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.