Highest annual salary in each country

[Spy3y3]

Good Morning, Afternoon, Evening, as your respected time,

Question => Find the employee with the highest annual salary in each country.

I got the answer to the above question but wanted to know if the workflow that led to my answer is a good way to go I have attached the answer file for your reference.

[gawa]

hi@Spy3y3 

A couple of suggestion.

In order to convert 'string' number, you can use ToNumber formula function. This is the simplest way to do so.

Summarize tool config to be reviewed again. With this, Summarize tool outputs Max salary of each country, but not sure the 'First_Full_Name" shown is corresponding to Full Name of the record having max salary. 

One way is like this: sort by country and salary(descending order), and sample first records(group by country)

At last, if you want to share your workflow with input raw data, try to export in yxzp format. Option=>Export Workflow

[Spy3y3]

Hi, 

Thank you so much for letting me know in detail. 

As shown in the image below, I have attempted the same formatting, but the first one did not work in the 'Full_Name' column

 

[gawa]

I just copy and paste what you configured in your shared WF. Try as per 2nd screenshot, Sort&Sample.

[gawa]

I just copy and paste what you configured in your shared WF to highlight what's wrong. Try as per 2nd screenshot, Sort&Sample.