Skip to main content
Question

Compare values in row/record

  • March 18, 2016
  • 2 replies
  • 10 views
djmcdermott
Contributor
Forum|alt.badge.img+7

Good day FME'ers,

I have two datasets containing a unique ID and postcode (zip code) field. I can join the datasets used on unique ID but I would like to compare is they have the same postcode. the unique ID is unique but the postcode is not. How do I perform a comparison in the same row.

Thanks,

David

    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

    david_r
    Celebrity
    • david_rCelebrity
    • March 18, 2016

    Hi

    If you've already joined the two datasets and your features have both postcodes already in them, you could use a Tester to compare the two values.

    If you need to join the two datasets using the postcode you could try using the FeatureMerger. In particular, look into the setting "Process duplicate suppliers" for your non-unique postcodes.

    David

    djmcdermott
    Contributor
    Forum|alt.badge.img+7
    • djmcdermottContributor
    • Author
    • Contributor
    • March 18, 2016

    Hi

    If you've already joined the two datasets and your features have both postcodes already in them, you could use a Tester to compare the two values.

    If you need to join the two datasets using the postcode you could try using the FeatureMerger. In particular, look into the setting "Process duplicate suppliers" for your non-unique postcodes.

    David

    Thanks @david_r. My manager had the same thought as soon as I posted the idea. I left it up to see if anyone had any alternatives to a tester. Seems obvious to me now!

    Community Stats

    32,207
    Posts
    122,303
    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.