How to filter out record from source based on defined rule?

I have a table which contains name, value column
how can i take name with maximum value in astera centerprise software.

If I understand you correctly, are you asking how to get the top row in a dataset after sorting by value?

Is this table a database table?

i am looking to find the top row in a dataset after sorting by value. my data source is an excel file. can you please help me out how can i get only one value in the result based on the sort(being the highest).

Hi, One solution to this is to use the aggregate object after sorting the data using the sort object and select the First option in the aggregate function for all the fields you want to fetch.
Adding to that, if you only want to fetch a single field, you can only use an aggregate object and choose the Max option in the aggregate function for the field you want to get.