Page tree

 

Support | BlogContact Us | 844.332.2821

 

Contents:

This documentation applies to Trifacta Wrangler. Download this free product.
Registered users of this product or Trifacta Wrangler Enterprise should login to Product Docs through the application.

Contents:


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.

Action Menu

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

Rename the column.

Wrangle Rename Transform

Change type

Change the data type of the column. See Supported Data Types.

Wrangle Settype Transform

Edit column

Perform one of the following edits to the column:

Sort: Sort the values in the column by ascending or descending value. This command does not apply to some data types.

  • 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.
Move: Move the column to a new location in the dataset.

Duplicate: Create a copy of 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.

Drop: Drop this column from the output.

Wrangle:

Column Details

Explore the interactive profile of the column details. See Column Details Panel.

Wranglen/a

Find

Find and optionally 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.

Wrangle

Format

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

Filter the rows of the dataset based on literal or computed values from the column.

Wrangle Keep Transform

Clean

Clean the mismatched or missing values in the column, replacing values with fixed or computed values or removing the rows altogether.

Wrangle

Formula

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

Aggregate

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) .

Wrangle

Restructure

Change the structure of the dataset based on the values of the column.

Wrangle

Lookup

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 lookup transform.

 

Your Rating: Results: PatheticBadOKGoodOutstanding! 1 rates

This page has no comments.