Select Record with Oldest Date

[kheuer]

Hello,

I have a simple record set: SKU and First Date on List. I want to select the record with the oldest date on the list for each SKU and purge/ignore all others. What is the best way to handle this?

[jdunkerley79 · Accepted solution]

The easiest way is to use a Sort tool to sort by SKU then by First Date (both Ascending). Then use a Sample Tool to keep first 1 grouped by SKU.

This will leave you with the set you want

[kheuer]

@jdunkerley79 - fantastic! Thank you so much.