Skip to main content
Question

Compare two excel files, write the differences to a third file?

jhawks
Contributor
Forum|alt.badge.img+7

1st file example:   2nd file example:

dog                      dog

cat                       bird

bird                      cow

horse 

cow

Compare and write what’s missing from file 2 to a 3rd file. 

 

    3 replies

    s.jager
    Influencer
    Forum|alt.badge.img+16
    • s.jagerInfluencer
    • Influencer
    • July 25, 2024

    For something like that I’d use the ChangeDetector...

    nielsgerrits
    1 person upvoted this
    • nielsgerrits
      nielsgerrits
    jhawks
    Contributor
    Forum|alt.badge.img+7
    • jhawksContributor
    • Author
    • Contributor
    • July 25, 2024

    I’ve got this far, but Im lost on the outputs:

     

    geomancer
    Evangelist
    Forum|alt.badge.img+48
    • geomancerEvangelist
    • Evangelist
    • July 25, 2024

    You have to connect one of the datasets to the Original input, the other one to the Revised input.

     

    nielsgerrits
    hkingsbury
    s.jager
    3 people upvoted this
    • nielsgerrits
      nielsgerrits
    • hkingsbury
      hkingsbury
    • s.jager
      s.jager

    Reply


    Helpful Members This Week

    Community Stats

    31,223
    Posts
    118,399
    Replies
    38,824
    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.