Savant

Tools Overview

Verify that the input data matches the expected output, guaranteeing the correct column names and data types.

Adapter Tool ⭐️

Combine multiple datasets by stacking rows to consolidate similar data into one output.

Blend Tool ⭐️

Combine datasets based on matching fields, with the flexibility to handle different join types.

Dedupe Tool ⭐️

Cross joins between datasets with zero configuration, making it effortless to combine every row from one dataset with every row from another.

Explode Tool ⭐

Use the Filter Tool to isolate records based on conditions in your dataset, utilizing either the Builder or Expression options.

Filter Tool ⭐️

Use the Format Tool to modify and format your dataset by dynamically changing field names, data types, and other schema properties.

Format Tool ⭐️

Make API calls and retrieve data from external APIs.

Generic API Tool ⭐️

Perform joins similar to Excel's VLOOKUP; merge data from different tables based on specific conditions.

Join Tool ⭐️

Parse and transform JSON data into a structured format for analysis.

JSON Tool ⭐️

Utilize the power of Generative AI in your data preparation process.

Gen AI Tool ⭐️

Summarize and transform your data by grouping and aggregating values with the Pivot Tool.

Pivot Tool ⭐️

The Recursion tool recursively calculates data across levels in a parent-child tree.

Recursion Tool ⭐️

The Sample tool extracts specific data portions: first N rows, every Nth row, or a percentage.

Sample Tool ⭐️

Use the Split Tool to divide text fields into separate columns or rows based on a specified delimiter.

Split Tool ⭐️

Stack Tool ⭐️

Find missing records & non-matches between tables.

Subtract Tool ⭐️

Summarize tool groups, sorts, and aggregates data with functions like SUM, COUNT, AVG. Configure windows for detailed analysis.

Summarize Tool ⭐️

Perform complex aggregations on time series data without the need for extensive data parsing or extraction.

Time Series Tool ⭐️

The Transform tool is used to format, arrange and calculate data, just like you would in a spreadsheet.

Transform Tool ⭐️

Convert wide datasets into a long format.

Unpivot Tool ⭐️

Learn about the Savant tools and become and analytics master

Savant App

Savant Help

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Thinking...

Searching through sources...

Analyzing...

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you