The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Get min row column name
Teja_Varanasi
Member Posts: 17 
Contributor II
in Help
I have a table like this
A B C D
5 2 1 9
I should get C in the results tab. Is there any operator to do this? Can somebody please help.
A B C D
5 2 1 9
I should get C in the results tab. Is there any operator to do this? Can somebody please help.
Tagged:
0
Best Answer
-
BalazsBarany
Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 
Unicorn
Hi!
You could transpose your table so that the values are in rows, not columns. Then sort by the number column and Filter Example Range for getting the first (lowest) value. The former attribute name in the second column will be the one associated with the lowest number.
That's another way to do it. If you have multiple data rows (or expect to have them in the future), it might be better to use Loop Attributes.
There you would use Aggregate to get the minimum of the current attribute and Generate Macro to compare the current value to the lowest known value and remember the attribute belonging to that. This is a bit more complicated than the first approach.
Regards,
Balázs0
Answers