Skip to main content

Varicent ELT Help Center

Date add

Abstract

Add date and time information to your data set.

Add a new date column to your data with these options:

  • Current time (in UTC)

  • Column (add dynamically, based on another column)

  • Constant time

When to use this tool

Use when you need to add date and time information to your data set.

Input

The Date add tool requires one data input.

Configuration

Use the following configuration options to configure the Date add tool.

Configuring the Date add tool

  1. In , add your data source.

  2. Click symon_add_icon.png + Tool.

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

    Tip

    You can also find the Date add tool in the Calculate section.

  4. Connect the tool to your data set.

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

    Table 37. Date add tool configuration

    Field

    Description

    New column name

    Enter a name for your new column.

    Starts with

    Select what to start with. Choose from Current time, Column or Constant time.

    Add

    Select whether to add time. Choose from None, Value or Column.

    • None: Select this option if you do not add any additional time to your configuration.

    • Value: Enter a numeric value and select a unit of time, such as years, months, days, hours, minutes, seconds or miliseconds.

    • Column: Select the column and the unit of time, such as years, months, days, hours, minutes, seconds or miliseconds.