When you make selections in the Transformer page,  responds by posting a set of suggestions for transformations to apply to the selected data in the sample. You can experiment with these suggestions to see what properly transformations your data.

Select Something

Selection Hints:

As you move the cursor around the Transformer page, the cursor changes when it is over a selectable data element.

IconDescription

Value or values can be selected.
Column or columns can be selected.

In the data grid:

In the Column Browser or Column Details:

Transformation types without suggestions

The following types of transforms are not available through the suggestion cards. In most cases, these operations have too many parameters for a single set of selections to properly suggest the transformation.

Suggestion Cards

Based on your selections, relevant suggestions appear in suggestion cards:

Suggestion Cards

In the suggestion cards, the label at the top identifies the transformation type that is being recommended, followed by a brief preview of how the selection might transform the data. 

Tip: A suggestion card may contain multiple variants for each suggestion. For example, in the previous image the extract suggestion has many variants, which can be selected and reviewed by selecting the dots at the bottom of the card.

Additional suggestions may be available. Try horizontal scrolling the set of cards to reveal new suggestions.

For more information, see  Suggestion Cards Panel.

Decide on the Suggestion

Before you decide on the suggestion to follow, you can do one of the following:

Modify Suggestion

To make the suggestion work for your specific use, you might need to modify the step. For example, for the selected text, you might need to define a replacement value, which  may not be able to guess. Click Edit

For more information on how to modify, see Transform Builder.

Previews

As soon as you select a suggestion card, the changes are previewed in the Data Grid:

Previewed suggestion

In this manner, you can review the change before it is applied to the sample.

Tip: You can use the checkboxes in the status bar to display only the rows, columns, or both that are affected by the previewed transformation.

Iterate

Experiment away! Things to keep in mind: