Skip to main content
Question

remove specific records from spreadhseet

  • July 18, 2018
  • 1 reply
  • 7 views
S

I have a spreadsheet with two worksheets (sheet1 and sheet2). I have a second spreadsheet which lists all the records that need to be removed from both worksheets, the new edited output will be in sheet1_v2 and sheet2_v2.

How would you advise I move forward with this?

Many thanks

    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.

    1 reply

    takashi
    Celebrity
    • takashiCelebrity
    • July 18, 2018

    Hi @saqibamin, supposing that every record from the sheet1/sheet2 has unique ID as an attribute, and the second spreadsheet contains ID values of records to be removed.

    A possible way is, use a FeatureMerger to merge the records from the second spreadsheet to the records from the sheet1/sheet2 using the ID as join key, write the unmerged records into the sheet1_v2/sheet2_v2.

    The DatabaseJoiner or the FeatureJoiner could be used instead of the FeatureMerger.

    Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

    Community Stats

    32,207
    Posts
    122,305
    Replies
    39,891
    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.