Hi all,
I have a dataset which looks like this:
Train No | Distance | Origin | Destination |
1000 | 109 | A | S |
1000 | 131 | B | T |
1000 | 262 | C | U |
1000 | 107 | D | V |
1001 | 463 | E | W |
1002 | 468 | F | X |
1002 | 308 | G | Y |
1002 | 374 | H | Z |
A particular train travels through multiple routes. I need to first group the data train wise then select the highest distance for than train and show the corresponding origin and destination. I tried doing so using a summarize tool with train (group up) followed by distance (max). How do I get the corresponding origin and destination for this set?
In this example, output should look like this:
Train No | Distance | Origin | Destination |
1000 | 262 | C | U |
1001 | 463 | E | W |
1002 | 468 | F | X |
Would appreciate any help. Thanks!
Solved! Go to Solution.
@Suvasini
Just try another little different one.
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |