All Collections
What's New
February 2024 Updates
February 2024 Updates

Multi-path outputs, Blend tool, Filter multi-path, Template variables, Formatted JSON, Dynamic functions and Tableau upgrade

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:

Introducing Multi-Path Outputs

Our latest feature lets you output unmatched records for joining, subtracting, filtering and more – giving you more control and flexibility over your data.

What is Multi-path Output?

Multi-path Output allows you to output not only the matched records from your data blending and filtering tools, but also the unmatched records from either or both sides of the join or filter.

This means you can easily identify and analyze the records that did not meet your join or filter criteria, and use them for further processing, reporting or debugging. You can also combine the matched and unmatched records in different ways to create custom outputs that suit your needs.

Why is Multi-path Output important?

Multi-path Output gives you more control and flexibility over your data. You can use it to:

  • Improve the quality and accuracy of your data by finding and fixing errors, inconsistencies, or missing values in your unmatched records.

  • Enhance your data analysis by exploring and discovering new insights from your unmatched records, such as outliers, anomalies, or trends.

  • Optimize your data workflow by saving time and resources on manual data manipulation, and automating your output generation and delivery.

How to use Multi-path Output?

Multi-path Output is easy to use and currently compatible with all our blend and filtering tools. You can enable it by simply selecting the output option that best suits your needs from the menu in the configuration settings. You can choose to output:

  • Only the matched records (default option) of the join or filter

  • Only the unmatched records of the filter

  • Only the unmatched records from the left side of the join

  • Only the unmatched records from the right side of the join

  • Only the unmatched records from both sides of the join

  • The matched records and the unmatched records from the left side of the join

  • The matched records and the unmatched records from the right side of the join

  • The matched records and the unmatched records from both sides of the join

Ready to try Multi-path Output?

Multi-path Output is available now for all our users. To try it out, log in to your account and open any Blend or Filter tool. You can also check out our Blend and Filter tool product screenshots and tutorials below for more guidance.

We hope you enjoy this exciting new feature and find it useful for your data analytics projects. As always, we welcome your feedback and suggestions on how to make our platform better for you.

Happy analyzing!

Blend, baby, Blend!

😎 Everything just got so much better. Say goodbye to data blending headaches and hello to awesome with our new Blend tool.

Finally, no more VLOOKUPS, HLOOKUPS, XLOOKUPS and INDEX/MATCH. No more left, right, inner and outer join. No more join, union, filter and subtract. And no more spaghetti mess and broken spreadsheets.

Get hours and hours of your life back from painful data stitching, match troubleshooting, and multi-step processes.

With Savant's new Blend tool, combining data has never been easier. We've redefined data blending in 3 powerful steps:

  1. Pick your match fields

  2. Visually select the output parts from your input dataset

  3. Enjoy 1-click options to add unmatched data paths

With this leap forward in data blending, just set your match fields with column drop downs and then define your main output with a snappy point-and-click Venn diagram. Need special processing paths for unmatched records? With a click, you can add unmatched paths for either input.

It's never been faster, easier and more satisfying to blend data – all without the spaghetti processes and fragile code.

🍹 Welcome to low-click, no-keyboard Data Blending!

Multi-path Filtering

Ever need to split your dataset in two? Want to monitor for records that fail an important test?

Often times, it's not enough to just get the records that pass your filters – you need to treat the other records too.

Now you can filter and segment in 1-click with this major enhancement to the Filter tool! Simple click Include false path in your Filter tool and enjoy multi-path Filtering.

It's an amazing feature for setting bad record alerts, splitting data flows and so much more. Enjoy the easy button!

Dynamic Slack and Email Reports

Time to celebrate with tons of major new file options for Slack and Email destinations. Ever need to split reports into multiple files and tabs? Or perhaps dynamically name files?

Well this major update can do all of those things! Now you can dynamically name and split into:

  • Multiple Excel files

  • Multiple Excel tabs

  • Multiple PDFs

Simply add fields to your datasets with the File and/or Tab names you want, set quick 2-click configs in your destination node and Savant will do the rest 😎

Track Analysis Changes with the Change Audit

Now you can see what's changed in your analysis overtime! Simply choose to analysis runs to compare and we'll build a Change Audit report for you.

Whether you're doing taxes and accounting, sales calculations, marketing attribution or other high-powered analytics, it's perfect for monitoring and auditing important and sensitive projects.

Stay Alert with MS Teams Operational Notifications

Need one place to monitor all of your operations? Now you can enable Org and Workspace level notification streams directly in Microsoft Team!

With this trusty tool, you can receive a centralized stream of all job start, success, failure and warnings notifications.

Have your admin set it up today. Simply set up a system connection to Microsoft Teams, and then go to the Notifications section of the Admin page.

Invariably Better Templates

A lot of analysts are building amazing, time-saving analysis templates to quick-start common projects.

And many of their best analyses use Input Variables – like picking a opportunity stage for attribution, start and end dates for a report, and tons more – to let them parameterize inputs in their process.

That's why we've Input Variables are not just for analyses – now you can build them into your templates too. With template variables, you can build variables into your re-usable analysis templates to get maximum efficiency, leverage and performance. The process is just like using variables in your analyses, but not they'll come packed in templates too.

No more hard-coded inputs and digging through workflows to make small changes. Create variables, input them in your templates and give your users super powers with no learning curve.

No More JSON Eye Sores

With the new JSON_FORMAT() function, never suffer for dense, hard-to-read JSON again. Now you can take ugly JSON blobs and auto-format them with white space, line breaks and indentation.

Whether you are just trying to read JSON in your analysis, or provide pretty JSON for you final report, the JSON_FORMAT() tool has got what you need!

More Dynamic Functions

Savants are clever and build amazing, dynamic analyses. So to give you even more control and power in your work, we've upgrades these features to allow field inputs in all of the inputs:

  • REGEX_EXRACT()

  • REGEX_MATCH()

  • REGEX_REPLACE()

  • REGEX_SEARCH()

  • HASH()

  • LOG()

  • CEIL()

  • FLOOR()

Welcome to fully dynamic functions, for dynamic analysts.

Facebook Ads Upgrade for BIG DATA

facebook-ads-logo – The Sargent

We've introduced asynchronous import from Facebook Ads, allowing for HUGE data syncs.

Have huge Facebook Ads data and want to take advantage of this update? It's already baked in with no extra work required. Just connect to Facebook Ads and we'll do the rest.

Tableau Upgrade for BIG DATA

Our Tableau destination connector has had a massive upgrade for higher fidelity create and replace of HUGE datasets in Tableau.

It's getting better, it's getting better all the time.

Google Ads Upgrade for Granular Time Windows

Google Ads SVG Vector Logos - Vector Logo Zone

Introducing more granular time controls when importing Google Ads data. It's perfect for rapidly pulling the most recent data, or building a larger time-series analysis.

Now you can choose options for:

  • 3 Days

  • 7 Days

  • 14 Days

  • 30 Days

  • 60 Days

  • 90 Days

Did this answer your question?