Pivot, reshape, and apply column-level transformations. Add, rename, hide, and reorder columns from a single panel, and preview every change instantly.
Every table you open in the transformation workspace can be reshaped before you save, export, or sync it. Column-level changes-adding, renaming, hiding, and reordering-are all made from the Columns panel, and the Data Preview updates immediately so you can confirm the result before moving on.
Add Column creates a new column in the active table. Use it for calculated values, derived fields, default values, or columns required by a destination system.
Rename columns directly in the Output columns panel to make field names clearer, standardize naming conventions, or match the requirements of a destination system.
Use clear, consistent column names and avoid duplicates. Double-check naming requirements before exporting to an external system.
Hide columns you don't need while working with a large dataset. Hidden columns stay out of the Data Preview and are excluded from exports until you show them again.
Hiding a column only affects the workspace view and outputs- it doesn't delete data. Re-enable visibility any time to bring the column back.
Reorder columns to control how fields appear in the dataset- useful when preparing data for reports, exports, or systems that require a specific column order.
The Data Preview shows the current state of your active table- row count, query time, column names, order, and generated values-so you can confirm the result of a transformation before saving or exporting.
If you need assistance adding, renaming, hiding, or rearranging columns in your datasets, our support team is here to help.
Contact Support