How to identify values with min-function?

eldenoso

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 :-)

MartinLiebig

Hi,

 

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

 

Best,

Martin

eldenoso

Thank you Martin,

that workend perfectly! :-)

 

Best,

Philipp