Extract values from column 1 of table based on value in column 2

[adityagarg]

I have a table which shows the model name along with their r-squared values. I want to extract the model name corresponding to the highest r-squared value. I want to use this model name to use this model for further analysis purposes. Below is the snip of the table

From the table above, I am expecting to store "RF_Prediction" in another variable where I can use that in "IF" command

[somesoni2]

Other option would be:

your current search  | sort 1 -r_squared

[kamlesh_vaghela]

@adityagarg

Try this:

YOUR_SEARCH | eventstats max(r_squared) as max_r_squared | where r_squared=max_r_squared

This will give you model name corresponding to the highest r-squared value.