The Wrangler UI consists of the following components.

Wrangler connections

Before you can import a dataset in Wrangler, you need to create a connection to the source system.

For more information about connections, see Managing Connections.

Wrangler Data page

The Wrangler Data page is where you parse, blend, cleanse, and transform datasets. On the Data page, you can:

• Use the drop-down menu in each column to add transformation steps to a recipe.

• From the Transformation steps tab, you can view the steps in a recipe or delete steps from the recipe.

• Click the More button to view the schema for the dataset.

• Click the green plus sign to upload a custom directive.

• Create a data pipeline that includes the source plugin for the dataset and the Wrangler transformation that includes the recipe with the transformation steps to execute when the pipeline runs.

• In the Pipeline Studio, configure the Wrangler transformation. You can add user-defined directives in the Wrangler transformation. Currently, clicking the Wrangle button in the Wrangler transformation is not supported.

• Use Power Mode to add directives and functions to the recipe.

Wrangler has a data quality bar that provides visual clues to help you quickly see columns with blank fields.

Open

Using the point-and-click method to build a recipe

In Wrangler, you can add directives and functions to a recipe from the user interface or from the command line. Just click on the drop-down menu for a column and select directives and functions to help you cleanse and transform your data. The directives and functions display under Transformation steps.

Open

The list of available directives and functions depends on the data type of the column. For example, you cannot use Numerical functions on a String column. Likewise, you cannot use Format functions on an Integer column.

Wrangler Power Mode (CLI)

You can use the Power Mode (CLI) to specify directives using declarative syntax instead of point-and-click UI interactions. Power Mode is especially useful for directives that are not available in the UI and for adding user-defined directives. It’s also useful if you want to apply a directive to multiple columns.

The Power Mode is the black bar located at the bottom of the Data page.

Wrangler Insights tab

You can use the Insights tab to perform data discovery on a dataset.