Savant

Tools

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

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

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

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

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

Make API calls and retrieve data from external APIs.

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

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

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

Just like Excel Pivot tables, the Pivot tool allows users to transform data from a row-based format to a more structured tabular layout.

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

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

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

Find missing records & non-matches between tables.

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

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

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

The Unpivot tool is designed to normalize data and simplify complex use cases for both new and experienced users.