I have a csv file that I need to import which looks like:

item quanty location

smurf1 50 ny

smurf1 60.2 nv

smurf1 20.1 mn

smurf1 24 ca

smurf1 12.2 il

smurf1 7 fl

smurf1 58 tx

smurf2 91.66 nv

smurf2 90.66 ny

smurf2 22 mn

smurf2 64 ca

smurf2 33.25 il

smurf2 51.2 fl

smurf2 2 tx

The info I need is which three locations have the lowest stock.

So in the above example it would be:

smurf2 tx 2

smurf2 mn 22

smuf2 il 33.25

smurf1 fl 7

smurf1 il 12.2

smuf1 ca 24

I know this can be done via a portal but this creates duplicates of each of the three lowest fields. I need to somehow be able to export out of this FMP7 file a list of records that for each item has the lowest three locations and qty. For example:

Item loc1 qt1 loc2 qt2 loc3 qt3

Smuf2 TX 2 mn 22 il 33.25

Smuf1 fl 7 il 12.2 ca 24

Any help would be great!

I just got it. All I need to do is use a simple duplicate script that numbers the duplicates according to sorted qty. Then search for the number 1, 2, 3 and export. Easy