Extract from date

Extract from date




DataPrep provides various options to extract part of date values into a new column. The portions which can be extracted are:
  1. Year
  2. Quarter and year
  3. Month and year
  4. Week and year
  5. Date
  6. Time
  7. Quarter
  8. Month
  9. Week
  10. Day of the week
  11. Day of the month

To extract part of a date

  1. Right-click a date column and select the Extract icon from the context menu.
  2. Enter the column name under New column name.
  3. Choose the portion to be extracted from the options provided. 
      

      4. You can apply this transform to multiple columns. Select the columns using the  option under Columns to apply. 

SEE ALSO