Updated aggregate transform: Find first and last record

Improvement
March 12, 2021

The aggregate transform has two new options "Find first and last record". Using these options, you can retrieve the first or the last record in a given column for a group.

Let's say you work at a bank and want to see the customer's first and last transaction in the last month. With this new option you can do that in seconds!


select *

Updated aggregate transform: Find first and last record

Improvement

The aggregate transform has two new options "Find first and last record". Using these options, you can retrieve the first or the last record in a given column for a group.

Let's say you work at a bank and want to see the customer's first and last transaction in the last month. With this new option you can do that in seconds!


Create data notebooks with Intersect Labs

This is your gateway to the magical land of Intersect Labs, where we help you streamline your data processes.
Get free access