Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
Get min row column name
Teja_Varanasi
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.
Find more posts tagged with
AI Studio
Aggregate
Accepted answers
BalazsBaranyRM
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ázs
All comments
BalazsBaranyRM
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ázs
Teja_Varanasi
Thank You, it helped
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups