Skip to main content
Solved

get minimum and maximum per record

  • December 4, 2019
  • 3 replies
  • 541 views

tnarladni
Enthusiast
Forum|alt.badge.img+16

So I'm trying to get the max and min of a row of data across all attributes (all number attributes).

I used the list builder and got all the attributes into a list, except it is like this _list{}.col1, _list{}.col2, etc

There are 54 attributes so I'm not sure how to combine all the parts together to get the min and max. I can't use listSorter as it is asking me to pick _list{}.col1..._list{}.col55 when I want to sort _list{}. Is this a nested list? is there to flatten it it maybe?

Maybe there's a better way to go? Would appreciate some help. Thanks

Best answer by erik_jan

You can use an AttributeCreator and calculate the min and max values using a Arithmetic Editor with the min and max functions, listing all attributes:

Hope this helps.

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

3 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • Best Answer
  • December 4, 2019

You can use an AttributeCreator and calculate the min and max values using a Arithmetic Editor with the min and max functions, listing all attributes:

Hope this helps.


tnarladni
Enthusiast
Forum|alt.badge.img+16
  • Author
  • Enthusiast
  • December 4, 2019
erik_jan wrote:

You can use an AttributeCreator and calculate the min and max values using a Arithmetic Editor with the min and max functions, listing all attributes:

Hope this helps.

gosh. I sometime can't seem to see simple solution. thank you. I was trying to do it without having to put named attributes, but since they don't change, this works.


bwn
Evangelist
Forum|alt.badge.img+26
  • Evangelist
  • December 5, 2019

@tnarladni, if you are like me and hate things like putting together a formula with 54 separate attributes into one formula (because I'm lazy!), there is possibly an alternative that avoids that like below. Suggest looking at ListExpressionPopulator. To use this, all you need to do is add Prefix characters to the Attributes you wish to build into a single list by using something like BulkAttributeRenamer and then use this prefix as the search string for ListExpressionPopulator to choose which attributes to build into a single field list.

A few more Transformers involved, but saves probably a lot of formula text!


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