Extract Transformation: Get a Date Component

Use the Extract transformation to pull a selected component from a date field into a new field. For example, extract the hour component from the Case Created Date field to analyze case creation by hour of the day.

1. In the Transform node, select the date field that you want to extract a component from.
2. In the Transform toolbar, click the Extract button () to set the extract settings.
3. Select which date component to extract.
4. Under Show Results In, select whether the new values appear in a new field and whether to keep the original field.
5. If you elect to create a field, set the label under Field Label.
6. Click Apply to add the transformation to the Transform node. The Preview tab shows the new date component field.
7. To view the canvas, click the Collapse button ().
8. Save the data transform.