How to find Highest value in Excel putting with out any hard coded value in stages

[NaveenG]

Hi All, I have faced one of interview quesation, I have 10 rows, field names are Name, employee salary. we have to find out who have highest salary in table. here is some conditions , should not use hard coded values in any stages.. -- Naveen

[MariusPuzaras]

Hey NaveenG, You could use Collection Manipulation BO - Sort Collection action to sort the column employee salary in a descending order and then simply extract the first row name using a calculation stage. Hope this helps. -Marius