Skip to main content
Solved

Need to compare two values in two separate tables

  • March 12, 2024
  • 1 reply
  • 98 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.

View original
Did this help you find an answer to your question?

1 reply

ctredinnick
Supporter
Forum|alt.badge.img+18
  • 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.


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