How to identify values with min-function?

eldenoso
eldenoso New Altair Community Member
edited November 2024 in Community Q&A

Hello altogether,

 

currently I am facing a problem concerning the finding of specific numbers if my examples. What I am trying to achieve is to find the minimum of eight different columns for each row of the example set. Unfortunately it is possible that there is no distinct value for a minimun, e.g. that there are two min's of the same value, thus the generate attribute operator shows a question mark. Is there any work-around for that?

I attached a picture of the data.

 

 

P.S. the function used for the generate attribute operator is the following:

if(min([Ge Akr],[Ge Dpl],[Ge Kar],[Ge Pal],[Ge Rol],[Ge St],[Ge TTE])=="",1,min([Ge Akr],[Ge Dpl],[Ge Kar],[Ge Pal],[Ge Rol],[Ge St],[Ge TTE]))

Thank you for your help.

Philipp :-)

Tagged:

Best Answer

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

    Hi,

     

    Generate Aggregation shoud be able to get you the minimum and then you check which attribute it is?

     

    Best,

    Martin

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

    Hi,

     

    Generate Aggregation shoud be able to get you the minimum and then you check which attribute it is?

     

    Best,

    Martin

  • eldenoso
    eldenoso New Altair Community Member

    Thank you Martin,

    that workend perfectly! :-)

     

    Best,

    Philipp

Categories