Skip to main content
All CollectionsWhat's New
April 2023 Updates
April 2023 Updates

Multi-tab files, Transform tool, New functions, JQL, Skip Rows, NetSuite, Oracle DB and OneDrive

Updated over 10 months 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:

Stitch Multiple Spreadsheets Tabs Together, Instantly

Tired of having to manually combine data tab? Let the bots do it.

Now you can create a single dataset from multiple tabs in an Excel workbook by simply selecting Multiple Tab. You can even add Tab Pattern rules to stitch together specific sets of tabs.

Introducing the Transform Super-Spreadsheet Tool

The Edit tool is now new and improved as the Transform tool. It has the functionality you love with a new look and feel for faster formula calculation and format editing.

Easy Button for Calculated Columns

<a href="https://downloads.intercomcdn.com/i/o/715693836/e903830b072d22c2e681e899/2023-04-19_13-51-02+(1).gif?expires=1734912000&amp;signature=8ce54eede98128fe2260e3b013b309296e2e371d920371e5018d52337c68e839&amp;req=cyEiEMB9lYJZFb4X1HO4gbAM%2FWWuT2Ehc6USTfadUatSeOclm8Jfo7pLzN3R%0A" target="_blank" rel="nofollow noopener noreferrer">https://downloads.intercomcdn.com/i/o/715693836/e903830b072d22c2e681e899/2023-04-19_13-51-02+(1).gif</a>

We've made it easier than ever to create new calculated columns in your data with just one click! Now, when you're in the Transform tool, all you have to do is click the "+ Column" button and you'll be able to quickly and easily create new columns with calculated data.

This feature will help you to streamline your workflow and make data analysis even faster!

New HTML Functions

Function

Result

ESCAPE_HTML("12&34")

12&34

UNESCAPE_HTML("12&34")

12&34

ESCAPE_HTML and UNESCAPE_HTML have been added to automatically encode and decode HTML, respectively. This allows for a more efficient way of handling HTML strings.

New Daylight Savings Functions

Savant has recently unveiled two new functions, to assist users in making time zone shifts that account for Daylight Saving Time (DST).

These functions return a Boolean value of either "true" or "false", allowing users to add or subtract an hour from a time zone shift.

IS_DURING_DAYLIGHTSAVING() will return a value of 0 if true and 1 if false, while IS_DURING_STANDARD() will return a value of 0 if true and -1 if false.

Turbo Charge Your JIRA Analyses with JQL

Savant now makes it easy to use your favorite JIRA reports in Savant. Simply drop your JQL into the JQL tab, and pull in your favorite JIRA reports for deeper analysis.

Skip Rows during Data Import

Have an import Excel data table that doesn't start on the first row? We've got you. Simple use the Skip Rows option to set where your data begins, and we'll do the rest.

NetSuite Analytics Warehouse

<a href="https://downloads.intercomcdn.com/i/o/715706369/3f28076017a51b2b596e9112/718-7189884_oracle-netsuite-logo-png-transparent-png.png?expires=1734912000&amp;signature=03a52ffd5b066ce4ad70d365608dceedb1d7ecae2eeacd66108d8a21f2e8e7da&amp;req=cyEiEcl4nodWFb4X1HO4gRG2AUThmBXJNaBM2B4HuBVmDYlBvFlD4GtuKEi8%0A" target="_blank" rel="nofollow noopener noreferrer">https://downloads.intercomcdn.com/i/o/715706369/3f28076017a51b2b596e9112/718-7189884_oracle-netsuite-logo-png-transparent-png.png</a>

Unlock the power of your NetSuite data with Savant's new connector to the NetSuite Analytics Warehouse! Get the insights you need faster with Savant's real-time analysis of your NetSuite data. Be in control of your data and make smarter decisions with Savant's comprehensive data analysis capabilities.

Try Savant's NetSuite Analytics Warehouse connector today and start uncovering the power of your data!

Connect to Oracle DB

Savant now supports read and write to Oracle Databases. Let's go!

Connect to OneDrive with Your Personal Account

Do you have important data that exists in a personal OneDrive account? In addition to business accounts, you can now use personal accounts to authenticate OneDrive in Savant.

Did this answer your question?