Skip to main content

Varicent ELT Help Center

Date part

Abstract

Extract specific date information from a date column.

Extract specific date information from a date column. You can select any of the following values:

  • Year

  • Month

  • Quarter

  • Week

  • Day

  • Weekday

  • Hour

  • Minute

  • Second

You can also opt to select all values or none of the values in the configuration.

When to use this tool

Use when your data set contains a general date column, and you want to break it down further.

Input

The Date part tool requires one data input.

Configuration

Use the following configuration options to help create your Date part configuration.

Configuring the Date part tool

  1. In , add your data source.

  2. Click symon_add_icon.png + Tool.

  3. In the search bar, search for Date part. Click + Add tool.

    Tip

    You can also find the Date part tool in the Clean section.

  4. Connect the tool to your data set.

  5. In the configuration pane, enter the following information:

    Table 48. Date part tool configuration

    Field

    Description

    Target column

    Select the target column.

    Date Parts

    Select the date parts to extract specific date information.