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
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
2. Hide/Show Fields
3. Data Type Conversion
4. Rename Columns
5. Jump to Column
6. Reordering Fields
7. Bulk Actions
8. Additional 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.
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
2. Building Expressions
3. Search Function Syntax
4. Update Columns
5. Savant Copilot
6. Editing and Deleting Calculated 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.