You can use the menus available at the top of a column to change its data type or perform other actions on the column data. Column menus are available in the following pages:
Depending on the data type of the column, the available options may vary.
NOTE: In the Column Browser panel, you can select multiple columns at the same time. The displayed column menu items are only the ones that apply to columns of all data types.
Data Type Menu
On the left side of the column header, you can click the data type icon to review and select a different data type for the column. 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.
- Some options are available only for specific data types.
- In most cases, these actions result in a new step being inserted at the current location in your recipe. Before you apply one, you should verify that you are at the proper position in the recipe to apply this step.
Rename the column.
Tip: To prevent potential issues with downstream systems, you should limit your column lengths to no more than 128 characters.
Wrangle: Rename Transform
Change the data type of the column. See Supported Data Types.
Wrangle: Settype Transform
Move the column to the beginning or end or to a specified location in the dataset.
Perform one of the following edits to the column:Hide/Show: Hide display of this column. To redisplay this column, you must select it in the Column Browser. See Column Browser Panel.
NOTE: Hide/Show commands do not create transform steps. Hidden columns still exist in the output.
Explore the interactive profile of the column details. See Column Details Panel.
Show related steps
Highlight steps in the recipe panel where the selected column is referenced.
- If another column is dependent on the selected column, all steps pertaining to that column are highlighted as well.
- To dismiss the highlighting, click Clear at the top of the recipe panel.
Find and replace specific values or extract patterned values from the column.
NOTE: The Extract menu option is available only for columns of String and Datetime type.
Format the values in the column according to the selection.
NOTE: This menu is available only for columns of String and Datetime type.
Wrangle: Set Transform
Filter the rows of the dataset based on literal or computed values from the column.
Wrangle: Keep Transform
Clean the mismatched or missing values in the column, replacing values with fixed or computed values or removing the rows altogether.
Generate 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.
Wrangle: Derive Transform
Generate summary table based on computations aggregated across groups (
aggregate transform) or add summary data as a new column in the current table (
derive transform) .
Change the structure of the dataset based on the values of the column.
Perform a lookup of the column values against a set of values in another column of another dataset. See Lookup Wizard.
Wrangle: Lookup Wizard generates a
Remove the column from the dataset.
Tip: You can also select Edit column > 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.