Loading
Prepare for Email to Become the Default Login ExperienceRead More
CRM Analytics
Extract Transformation: Get a Date Component

You are here:

  1. Salesforce Help
  2. Docs
  3. CRM Analytics

Extract Transformation: Get a Date Component

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
  1. In the Transform node of a Data Prep recipe, select the date column you want to extract a component from.
  2. In the Transform toolbar, click the Extract button (Extract from date 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 column and whether to keep the original column.
  5. If you elect to create a column, set the label under Column Label.
  6. Click Apply to add the transformation to the Transform node. The Preview tab shows the new date component column.
  7. To view the Graph area, click the Collapse button (Collapse button).
  8. Save the recipe.

After you run the recipe, the selected date component is extracted in the specified text (dimension) column.

 
Loading
Salesforce Help | Article