Skip to main content
Solved

Need to compare two values in two separate tables

  • March 12, 2024
  • 1 reply
  • 126 views
vxn43
Supporter
Forum|alt.badge.img+18

I have two Excel Files. You can see from the screenshot, in the Visual Preview, I need to compare 95137 and 95138 in a Tester. Before I can do this, I need to “move” 95137 to row 1 (highlighted in yellow in the screenshot below) and have only one row in the table not two, what is the best way to make this happen?

 

 

 

Best answer by ctredinnick

You’re wanting to use an Aggregator, aggregate attributes only, and have it set to Merge Attributes. That’ll flatten it to one feature, and resulting attributes will be from any input feature which had a value there.

    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

    ctredinnick
    Supporter
    Forum|alt.badge.img+19
    • ctredinnickSupporter
    • Supporter
    • Best Answer
    • March 12, 2024

    You’re wanting to use an Aggregator, aggregate attributes only, and have it set to Merge Attributes. That’ll flatten it to one feature, and resulting attributes will be from any input feature which had a value there.

    nielsgerrits
    hkingsbury
    vxn43

    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.