In the Transform by Example page, you can build new columns of data by specifying values to map from the selected source column. For the column to transform, select Create column by examples from the column menu.

NOTE: Transformations by example are developed using the current sample. When the finished transformation is applied across the entire dataset, some source values may not be matched by the patterns you specified using the current sample.

Tip: Transformation by example works best for text-based inputs. For non-text inputs, you can convert the column data type to String.

To transform by example, you can use either of the following:

For more information on these types of transformations, see Overview of TBE.

Transform Builder

In the Transform Builder panel on the right, you can review and change the Source and Preview columns to transform.

Tip: To transform from a different source column, select a new column from the Example column drop-down. This step clears all examples from the transformation you are building. Some columns may not be available for selection. To use such a column, change its type to String first.

Grid View

In grid view, the Source values for each row in the sample are listed next to an empty Preview column. You can create mappings by selecting a cell in the Preview column and manually entering a value. 

Transformation by Example - Grid View

After you enter a value,  attempts to match other values from the Source using the same pattern to generate additional values in the Preview column.

Tip: Values that have been inferred can be replaced by manual entries for further refinement.

For more information on how to use, see Create Column by Example.

Keyboard shortcuts

Tip: You can copy and paste values from the clipboard into the Preview column.

Pattern View

In Pattern view,  performs some preliminary pattern detection to group Source values together. Transformations are processed using .  

Transformation by Example - Pattern View


Transformation by Example toolbar