Conversions Transform

The Conversions transforms allow users to change the data type of columns to ensure data consistency and compatibility for various processing needs.

Convert Duration

The Convert Duration transform allows users to convert time durations from one unit to another, such as days, hours, minutes, seconds, or milliseconds. This transform is useful for standardizing time-based columns for analysis, reporting, or further transformations.

Best Situations to Use

Use the Convert Duration transform when you want to:

• Standardize time-based measurements across datasets.

• Convert durations to a more convenient unit for analysis (e.g., days → hours).

• Perform calculations on time intervals consistently.

• Prepare datasets for aggregation or visualization that require uniform time units.

Not Recommended for:

• Non-time-based columns.

• Already standardized datasets where no conversion is needed.

Steps to Perform Convert Duration

1. Navigate to the Data Preparation workspace.

2. Select a column containing the duration values to convert.

3. Open the Transforms tab.

4. Select Convert Duration under the Conversion category.

5. In the Convert Duration dialog box, configure the following:

   • Create New Column: Enable to output results to a new column (optional).

   • From: Select the source interval unit (e.g., days).

   • To: Select the destination interval unit (e.g., hours).

   • Precision: Specify the number of decimal points to retain.

6. Click Submit.

• A new column is added (if selected) with values converted to the chosen duration unit.

Example: A column with values in days is converted to hours, with each value multiplied by 24.

Notes:

• Ensure that the source column contains valid time durations.

• Choose an appropriate precision to balance accuracy and readability.

• This transform is particularly useful when datasets contain mixed duration units that need normalization