| Excerpt |
|---|
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:
...
| Method | Description |
|---|
| 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:
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 |
|---|
| inCQL | true |
|---|
| label | (label = "cleanse_tasks") |
|---|
|
