Finding the best result for each unique entry

[miter]

Hi, any help would be appreciated on this.

Simplifying my problem a great deal - file is actually several million multiple field records of which 95%+ I need to discard

How would I get FM to find only the lowest number in field2 for each field1 entry and to discard the rest? I am struggling with this!

field1 - field2

A - 1

A - 2

A - 3

B - 4

B - 5

B - 6

C - 7

C - 8

C - 9

i would need it to return only 3 records for this example

A - 1

B - 4

C - 7