Skip to main content
Solved

Compare attributes


mr_fme
Enthusiast
Forum|alt.badge.img+9

I have two data stream, both have count attribute. I would like to compare the count_1 and count_2, if the count_1 > count_2 the set attributes by count_1 go ahead...if count_2 > count_1 the set attributes by count_2 go ahead.

Thank´s

Best answer by takashi

The Tester processes input features one by one, separately. That is, it can compares attribute values within a single feature, it cannot compare attribute values among different features.

I cannot understand your intention correctly from the screenshot, but if you need to select only features that have the max value in 'ATTRIBUTE_1', a possible way is: get the max value in 'ATTRIBUTE_1' with the StatisticsCalculator, merge the Summary feature from the StatisticsCalculator to the original features unconditionally, then test if 'ATTRIBUTE_1' is equal to the max value.

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

5 replies

takashi
Influencer
  • August 14, 2018
Could you please explain your requirement more specifically?

 

For example, if the first data stream was:

 

count_101234and the second data stream was:

 

count_201234then, what is your desired result?

 

 


siennaatsafe
Safer
Forum|alt.badge.img+11

Hi @mr_fme,

I think I understood what you are asking, but if I missed something please let me know. I created a workspace that combines two excel files with count values into one file and keeps the highest count value. I used an example with fruit to keep in simple. 2018-08-14-15-39-03.png

So the two sheets are read in and I renamed the Count to either Count1 or Count 2.

I joined the tables together so each row would contain the fruit name, Count1, and Count 2.

Then I used the AttributeManager, to create a conditional statement. To do that select the Attribute Value and select the drop-down. Then click Conditional Value and I set it to. If Count1 > Count2 then set the value to Count1. If Count2 > Count1 then set it to Count2. Else (the values are equal) do nothing. 2018-08-14-15-30-14.png

Then I removed Count2 in the AttributeManager.

Let me know if that helps!


mr_fme
Enthusiast
Forum|alt.badge.img+9
  • Author
  • Enthusiast
  • August 15, 2018

Let explain more clearly.

My workspace like this

I would like to filter so that the highest number of features always goes ahead. It´s possible!?


takashi
Influencer
  • Best Answer
  • August 15, 2018

The Tester processes input features one by one, separately. That is, it can compares attribute values within a single feature, it cannot compare attribute values among different features.

I cannot understand your intention correctly from the screenshot, but if you need to select only features that have the max value in 'ATTRIBUTE_1', a possible way is: get the max value in 'ATTRIBUTE_1' with the StatisticsCalculator, merge the Summary feature from the StatisticsCalculator to the original features unconditionally, then test if 'ATTRIBUTE_1' is equal to the max value.


paalped
Contributor
Forum|alt.badge.img+5
  • Contributor
  • August 15, 2018

Looks like your looking for FeatureCounter, which counts all features in a stream, you can compare this to numbers of features in another stream.


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