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.
