string sorting

[BRRLL99]

hi

I have data with different countries, company

my target is to pick each country with highest assets

country	company	sales	profit	assets
india	A	10	1	100
india	B	20	2	200
india	C	30	3	300
usa	D	40	4	200
usa	E	50	5	300
usa	F	60	6	400

output:

country	company	sales	profit	assets
INDIA	C	30	3	300
USA	F	60	6	400

[IraWatt · Accepted solution]

Hey @BRRLL99,

One way to do this is with a Summarize tool and a join Tool. The summarize lets you get the max asset for each country then you can use a join to get all the information for that record:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[DataNath]

Could just sort the data by asset and then pick the first 1, grouping by country: