Transform Tool ⭐️

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

Updated over a week ago

The Savant Transform tool is used to manipulate and transform data to gain deeper insights and perform complex data operations without the need for coding.

Add a Transform Tool

1. Navigate to your analysis.

2. Click this icon.

3. Click Transform.

4. Click "Edit in a tab" to open the Transform tool in a separate tab. This allows for more in-depth analysis and configuration.

Manage Columns

The Managed Columns tab is where you can work with all the columns and fields in your dataset. Here are the key functionalities available in this tab:

1. Search Bar

Use the search bar to quickly find specific fields or columns within your dataset.

2. Hide/Show Fields

By clicking the eye icon next to a field, you can hide or show it in your analysis. Hidden fields are not deleted but are hidden from the view in your analysis.

1. Click this eye to Hide a field.

2. Click Apply.

3. Click this eye to Show a field.

4. Click Apply.

3. Data Type Conversion

You can change the data type of a field by clicking the icon representing the current data type. A list of possible data types will appear, allowing you to select the desired data type.

4. Rename Columns

Click the pencil icon shown when hovering over a column to open the column name editor.

5. Jump to Column

The arrow icon (Jump to Column) allows you to quickly navigate to the specific column within your data set.

6. Reordering Fields

Use the move icon to drag and drop a field to a different location within your table, effectively sorting the fields. Click "Apply" to save the changes.

7. Bulk Actions

Select columns using the checkboxes next to each column's name in the configuration panel. This enables you to apply actions available in the Actions dropdown to multiple columns simultaneously.

8. Additional Options

Clicking the upside-down caret (arrow) in any of the header names opens a dropdown with additional options:

1. Click this icon to open the drop down menu.

2. Click from the available options.

  • Move Column: Move the selected column to the beginning, end, left, or right of a specific field.

    • Beginning: The first field in the table.

    • End: The last field in the table.

    • Left: Specify how many fields to move left.

    • Right: Specify how many fields to move right.

    • Before: Select a field to place the current field before.

    • After: Select a field to place the current field after.

  • Rename Column: Rename a selected column.

  • Transform Column: Apply custom expressions or use the expression builder to transform the data in the selected column.

  • Hide Column: Hide the selected column.

  • Insert Column Left/Right: Insert a calculated column to the left or add a calculated column to the right.

Calculated Columns

The Calculated Columns tab allows you to add and manage calculated columns, which are derived from existing data. Here's how to work with calculated columns:

1. Adding a Calculated Column

From the Managed Columns tab, click the "+ Column" button to add a calculated column. The Expression Editor will open.

2. Building Expressions

In the Expression Editor, type in a field name in the "Field Name" box and use familiar syntax from Excel or SQL.

3. Search Function Syntax

Alternatively, use the search bar at the bottom to find available functions and fields.

4. Update Columns

From the column header name dropdown, click Transform to edit the values in a column in your dataset. This allows you to perform transformations directly on the column's data.

5. Savant Copilot

Savant Copilot, which suggests usable formulas using natural language processing, is also available (in beta).

6. Editing and Deleting Calculated Columns

Use the summation button to edit a calculated column and the trash can icon to delete it.

Renamed Columns

The Renamed Columns tab displays any columns that have been renamed in your dataset from the Manage Columns tab.

Calculated Columns and Order of Operations

In the Calculated Columns tab, you can view the calculated columns you've added to the table and their order of operations and functions. Columns listed first will be processed before those appearing later down the list.

Did this answer your question?