Combining sort and unique tools

Next, we want to trim the dataset even more by finding the most recent sale date per unique property address and create a list of these unique addresses. The Sort and Unique tools can be combined to find specific criteria and create a subset of data.

In this example, we'll sort the subset of data on the sale date to find the most recent sale, then obtain the unique address, giving us one property address per record with the most recent sale date.

If you lost any progress, load the 2_2_custom_filter.yxmd from the Exercises folder on the Desktop.