In the Selection Details panel, you can review an active profile of your current selection or selections in the data grid or column browser and review patterns and suggestions for transformations.


Selection Details Panel for selected column

Based on what you have selected, the panel is updated with context-specific information about your selection(s) and a set of actions that you can take on the data.

Select Column

When you select a column, the following sections appear in the Selection Details Panel.

Data Quality Bar

Review the counts and percentages of valid, mismatched, and missing values in the column. 

Context menu:

Right-click the data quality bar to see a set of possible transformations:

Unique Values

You can review the counts of the most frequently occurring values in the column.

To see all unique values, click Show more values.

Context menu:

Right-click any value bar to be prompted for a set of transformations specific to the applicable rows and values.

Patterns

Based on your selected column or column values,  attempts to find patterns that match your selections. These patterns are represented as . For more information, see Text Matching.

To see all patterns, click Show more patterns. For more information, see Column Details Panel.

Context menu:

Right-click any pattern bar to be prompted for a set of transformations specific to the rows and values that match the pattern.

Other Selections

Select Multiple Columns

When you select multiple columns, the following changes to the panel apply:

You can access a column menu and review suggestion cards that are applicable to all of your columns.

Select Column Values

After you have selected a column, you can use the Selection Details panel to select individual values within the column, which updates the panel. Below, the mismatched values in the previously selected column have been selected from the data quality bar:

Selection Details Panel - selected column values

Review and make your choice among the available selections.

Select Values in the Data Grid

When you select values in the data grid, the Selection Details panel presents a set of suggestions for your review. See below.

Suggestions

Suggestion cards provide a means to select relevant suggestions for transform steps. The suggestions vary depending on the data you have selected. You can then use the cards to preview the results in the data grid, so that you are confident that the proposed transformation works for your dataset.

 

Tip: As you mouse over areas of the Transformer page and its panels, the Lightbulb icon appears next to the cursor to indicate that suggestions are available. Select the data to see the suggestion cards.

In the following example, your dataset contains a column of addresses. Within one of the values, you can select a zip code, which then triggers an appropriate set of suggestion cards:

Suggestion Cards

In the above image, the first suggestion in the Extract values matching suggestion card has been selected by default, and its parameters have been specified to extract all zip codes from the source column (Address). While useful, this selection may not be your intention. Options:

  1. Hover over different suggestions. A mini-preview appears to the left of the suggestion.

  2. Click a different suggestion in the same card. In this case, you might click the first suggestion in the Replace card, so that you can remove zip code.

    Tip: Among the suggestion cards, scroll down to see other suggestion cards that are off-screen. If it is present, a See all link displays more suggestions in that card. Variants further down in the suggestion card typically become more specific in their changes to the dataset or rarer in their usage.

  3. Modify the selected transform. To edit the step, click Edit. You can fine-tune parameters of the transformation. See Transform Builder.

Actions: