You can use the menus available in a column context menu to perform a variety of actions on the column or columns.
Column menus are available in the following pages:
On the left side of the column header, in the Data Grid you can click the data type icon to review and select a different data type for the column.
- When you select the Datetime data type, you can choose the format against which values in the column are validated. See Choose Datetime Format Dialog.
- For more information, see Supported Data Types.
On the right side of the column header, select the drop-down caret to choose one of the following actions.
Tip: Use the Column Browser panel to quickly locate and select columns for display or other actions. See Column Browser Panel.
Unlock the column's data type. For more information, see Change Column Data Type.
Rename the column.
For more information on column name requirements, see Rename Columns.
NOTE: Hide/Show commands do not create transform transformation steps. Hidden columns still exist in the output.
NOTE: When a column is hidden from a dataset, it is hidden for all users. You should check the column browser for hidden columns in shared datasets.
Sort: Sort the values in the column by ascending or descending value. This command does not apply to some data types.
NOTE: Sort is intended primarily for display purposes in the Transformer page. For more information on its limitations at scale, see Sort Transform.
When a column is sorted in ascending order, the bottom values are mismatched and null values, in that order. These values appear at the top of the column when sorted in descending order.
For more information, see Sort Rows.
Edit with formula
Modify the column values based on a formula that you input. For more information, see Transform Builder.
Format the values in the column according to the selection.
Calculate a new column containing the values computed from the source column based on the selected function. This command does not apply to all data types.
Summarize values in the selected column using an aggregation formula, optionally grouping the values according to values in the column.
Using a source column, you can create a new column using the source values as examples.
Tip: The transformation-by-example feature can be used in place of standardization or extraction transformations and may be simpler to use.
For more information on transformation-by-example, see Overview of TBE.
Group by minimum or maximum value, counts, or arbitrary function. See Create Aggregations.
Generate summary table based on computations aggregated across groups.
Restructure your dataset by converting column values to columns, nesting values into objects or arrays, and unpivoting your data.
Filter the rows in your dataset based on column values, duplicate values in the column, or other condition. See Filter Data.
Replace values in the selected column with based on text values, patterns, or delimiters. See Replace Groups of Values.
Standardize individual and clustered row values for consistency. See Standardize Page.
Extract values from the selected column based on text values, specific types of data, or patterns in the data. Optionally, extracted data can be removed from the source. See Extract Values.
Split the column into separate columns based on patterns, delimiters, positions in the value, or regular intervals throughout the value.
Explore the interactive profile of the column details. See Column Details Panel.
Tip: You can also select Hide to remove the column from display in the data grid. The column does remain as part of the dataset and is included in any generated results.
Delete the columns other than the selected column(s) from the dataset.
Copy, Cut, and Paste
You can copy and paste columns and column values into other areas of your dataset. For more information, see Copy and Paste Columns.
|D s also|