Pick One Copy of Duplicate Records

Some times we need to delete duplicate records. I used to define script with loop to do this automatically. But now I show a simple way to do this on an example:

We have some set of records shown in the image below. Assume that we want to make a list of box types, so we should delete duplicates in order to get box list.

There are 9 records in the table above, some products are placed in same box. To pick only one copy of each box sort the records by BoxNo field.

The second step is exporting records. The key point here is grouping, check BoxNo in Group By part of the dialog box.

Click export button. It is ok! Only one copy for each box type is exported. 

Click here to download example file (.fp7)