How to identify values with min-function?
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.