Skip to main content

Varicent ELT Help Center

Date add

Use the Date add tool to 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

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. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In Pipe builder, add your data source.

  4. Click symon_add_icon.png + Tool.

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

    Tip

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

  6. Connect the tool to your data set.

  7. In the configuration pane, under New column name, enter a name for your new column.

  8. Under Starts with, select what to start with, such as Current time, Column , or Constant time.

    Note

    The Current time is in UTC. For Column, it adds dynamically, based on another column.

  9. Under 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, such as when you want to time-stamp your data.

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

      Note

      You can also add negative values to the time. In the Values field, click the down arrow to decrease the number.

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