Extracting one or more values from within a column of values can turn data into meaningful and discrete information. This section describes how to extract column data, the methods for which may vary depending on the data type.
Extract and split transformations do not do the same thing:
|By selection||Select part of a value in the data grid to prompt a series of suggestions on what to do with the data. Typically, extract options are near the top of the suggestions when you select part of a value.|
|By column menu||From the menu to the right of the column, select Extract and a sub-menu item to begin configuring a transformation. See Column Menus.|
|By Transformer toolbar||At the top of the data grid, click the Extract icon in the Transformer toolbar to begin configuring extract transformations. See Transformer Toolbar.|
|By Search panel||In the Search panel, enter |
extract to build a transformation from scratch. See Search Panel.
The following functions can be used to extract values from a Datetime column, as long as the values are present in the formatted date:
You can also reformat the whole Datetime column using the
DATEFORMAT function. The following reformats the column to show only the two-digit year:
The following functions can be used to extract values from a set of URLs:
You can extract query parameter values from an URL. The following example extracts the
store_id value from the
storeURL field value:
|D s also|
|label||(label = "cleanse_tasks") |