In CRM Analytics, use the Extract transformation in a Data Prep recipe to pull a
selected component from a date field into a new field. For example, extract the hour component
from the Case Created Date column to analyze case creation by hour of the day.
Required Editions
Extract Transformation: Get a Date Component
| User Permissions
Needed |
| To manage and create a recipe: |
Edit CRM Analytics Dataflows OR Edit Dataset Recipes |
- In the Transform node of a Data Prep recipe, select the date column you want to
extract a component from.
- In the Transform toolbar, click the Extract button (
)
to set the extract settings.
- Select which date component to extract.
- Under Show Results In, select whether the new values appear in a new column and
whether to keep the original column.
- If you elect to create a column, set the label under Column Label.
- Click Apply to add the transformation to the Transform node.
The Preview tab shows the new date component column.
- To view the Graph area, click the Collapse button (
).
- Save the recipe.
After you run the recipe, the selected date component is extracted in the specified text
(dimension) column.
