With the new Shopify integration, you can pull valuable data from your Shopify store and use it to create custom data apps. Manage inventory, track orders, or build custom sales reports - these are some data apps that you can start implementing today.
Two weeks ago, we announced the PostgreSQL integration, which allowed you to connect your Postgres database and pull data directly into your data apps. With Intersect's newest updates, you can now write back to your Postgres tables using a very easy-to-use custom data mapping option.
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!