Summary
Converts a table with a column containing a date and two columns containing times into a table with two columns containing each date and time. Many operators require this format, e.g., the Scaling 8.2.
Version 2.0 passes through all other columns.
Example:
Configuration
Input settings of existing table
Name |
Value |
Opt. |
Description |
Example |
---|---|---|---|---|
Date (from) |
System.DateTime |
- |
Column for start date |
col1 |
From time |
System.DateTime |
- |
Column for from time |
col2 |
To time |
System.DateTime |
- |
Column for to time |
col3 |
Settings
Name |
Value |
Opt. |
Description |
Example |
---|---|---|---|---|
Ignore data sets with 0 minutes length |
System.Boolean |
- |
Should data sets whose length equals 0 minutes be ignored? |
- |
Ignore from-time = to-time = 0:00 |
System.Boolean |
- |
Should data sets in which the start time and the end time are 0:00 be ignored? |
- |
Count as 24 hours if from-time equals to-time. |
System.Boolean |
- |
Should data sets in which from time is equal to to time be counted as 24 hours? |
- |
Remarks
Converts an IDurations table (date/time/time) into a Durations table (date+time/date+time) in order to enable further operations (see Types of Tables), as some operators can only be applied to Durations tables, e.g., the operator Scaling 8.0.
Want to learn more?
Screenshot
Examples
Example: Convert all rows
Situation |
The file Import_5.txt with the following structure has already been imported with the operation Import text or CSV file with manual column assignment 3.0
|
Settings |
|
Result |
|
TIS Project |
- |
Example 2: Ignore rows with From=0:00 hours and To=0:00 hours
Situation |
The file Import_5.txt with the following structure has already been imported with the operation Import text or CSV file with manual column assignment 3.0.
|
Settings |
|
Result |
→ Missing due to an error in the operator. Ticket |
Example 3: If Start time = End time, count 24 hours but ignore the entries From=0:00 hours and To=0:00 hours
Situation |
The file Import_5.txt with the following structure has already been imported with the operation Import text or CSV file with manual column assignment 3.0.
|
Settings |
|
Result |
The entry of 2007/01/03 is not taken over into the result table, because both the From-column and the To-column values are 0:00. The entry of 2007/01/04 has a length of 24 hours. |
Troubleshooting
Problem |
Frequent Cause |
Solutions |
---|---|---|
The operator "Conversion" is not available... |
Often, this is due to a mistake in the preceding import (see Import text or CSV file with manual column assignment 3.0) |
Please check, if in the import operation under Type of the result column you have selected the type IDurations (conversion necessary). See also Tabellentyp (link to old Wiki). |
Related topics
- Operators (alphabetical overview)
- Scaling 8.0
- Scaling 8.2
- Format columns 2.0
- Tabellentyp (link to old Wiki)