Attach/Detach - Time

This tab enables you to add specific information about an already existing Datetime to your data, such as the categorization of certain days. It also lets you pair your data with Datetime.

Note

This tutorial assumes that you already selected a project and imported data. For more information please visit on Project and Import Data section.

User Interface Structure

Here we give a detailed description of all settings which you can define in this tab.

Signals

Choose all signals on which you want to apply the operation.

Pair with (Time/Datetime)

Choose the signal, which contains time or Datetime data that you want to use for the Attach method.

Viewer Specific Operations

The settings specified here are used for the Detach method. The following options can be enabled:

  • add Datetime 2 Sec Conversion - creates a signal which converts the Datetime into Seconds
  • add Datetime 2 vector of components (datevec) - creates additional signals with the extracted Year/ Month/ Day/ Hour/ Minute/ Second of the Datetime signal
  • add Business/ Holiday/ Weekend - creates a categorization for the days in the Datetime signal, for which the specified options are the case. For example, if the days Saturday and Sunday are selected as weekend they will have a 1 in the added signal. The other days will have a 0.

Filter

In all DataWrangling Tabs, you can select only a part of the data using a Filter. A more detailed description of Filters can be found here

Preview / Apply

Select Preview and see the new data set in the viewer area with the changes due to this operation. If you want to apply these changes permanently, select Apply. For a more detailed description, see Starting a Job.

Basic Usage

The methods Detach and Attach are available:

  • Detach is making use of settings specified in Viewer Specific Operations and decomposes the time signal or extracts information about it
  • Attach is making use of the Pair with dropdown menu and creates vector-value pairs for the given signals.

Image_Caption

Attach

This method is used to change regular values to vector-value pairs in order to have a Datetime/Time signal allocated to all other signals.

  1. Select the Attach method
  2. Choose input data with only values that you want to change into vector-value pairs
  3. In Pair with (Time/Datetime) choose the signal that should be used as the vector
  4. Apply

Detach

This method is used to apply certain operations on the time component of your signal. In case that the data only contains values it is therefore needed to perform the Attach method before proceeding. Depending on your settings in Viewer Specific Operations, you can add different information about the time signal to your data.

  1. Select the Detach method
  2. Choose input data with vector-value pairs
  3. Choose the settings for Viewer Specific Operations
  4. Apply