All Collections
What's New
July 2023 Updates
July 2023 Updates

Change data types, Transform existing columns, Headerless files, and Pivot aggregations

Updated over a week ago

Savants are always improving and their tools should too. That's why we're constantly releasing new features and enhancements every week. Here are the highlights from this month:

Change Data Types with Ease

Our transform tool now allows you to update data types with a single click. This feature offers significant time savings for analysts who need to make multiple data type changes while cleaning data. No more tedious manual updates!

Transform Existing Columns

Savant now lets you transform existing columns, enabling you to keep your schema clean and avoid creating new columns unnecessarily. This is an improvement over the previous method of creating a new column and hiding the original.

Import Headerless Data

We understand that data comes in all shapes and sizes. Savant now supports the import of headerless Excel and flat files. Simply choose the Headerless option, and Savant adds fields headers - preserving the top data row in your file.

This can even still be used in conjunction with our Skip Rows feature to give you full control over your flat file imports.

Aggregations Added to Pivot

Our Pivot tool now supports all aggregation options when selecting your pivot field. Want to get the count, min, max or sum of values in your pivot? One-click and you're there!

Hey Excel users, have you ever been stuck trying to combine multiple text values into a list when pivoting? We've got your easy button. Just use the Concatenate aggregation in the Savant Pivot tool and enjoy!

Did this answer your question?