Keeping up to N duplicate records

Typically, when you have duplicates, you use Dedupe or Unique transforms to remove all the duplicate records but one. However in some cases you might want to keep the first <= N records, e.g. the first 3 records. You can do that using Total and Filter transforms.

keep3.transform (2.5 KB)

Use Sort before Total if you want to control what N records you keep.

Absolutely genius ! Such a neat little trick !