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.
When you select a column, the following sections appear in the Selection Details Panel.
Review the counts and percentages of valid, mismatched, and missing values in the column.
Right-click the data quality bar to see a set of possible transformations:
truefor each row that matches the data quality bar you selected. Otherwise, the row value in the new column is
You can review the counts of the most frequently occurring values in the column.
To see all unique values, click Show more values.
Right-click any value bar to be prompted for a set of transformations specific to the applicable rows and values.
truefor each row that matches the selected value(s). Otherwise, the row value in the new column is
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.
Right-click any pattern bar to be prompted for a set of transformations specific to the rows and values that match the pattern.
truefor each row that matches the selected pattern(s). Otherwise, the row value in the new column is
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.
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.
When you select values in the data grid, the Selection Details panel presents a set of suggestions for your review. See below.
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:
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:
Hover over different suggestions. A mini-preview appears to the left of the suggestion.
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: Optionally, suggestions can be provided to you based on your prior transformations or the transformations of other users in your workspace. These suggestions appear under the Recently used heading. For more information on enabling collaborative suggestions, see Workspace Settings Page.
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.
If needed, you can customize the selected suggestion. Click Edit. See Transform Builder.