Data organisation : Grouping data

[Suvasini]

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!

[Emil_Kos · Accepted solution]

Hi @Suvasini,

You need to sort the data and then use the sample tool:

The output:

[Qiu]

@Suvasini 
Just try another little different one.