SOLVED
string sorting
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BRRLL99
11 - Bolide
‎08-08-2022
03:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
- Datasets
2 REPLIES 2
17 - Castor
‎08-08-2022
03:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
17 - Castor
‎08-08-2022
03:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
