Data Center
  • Data Center
    • Homepage
    • Data Connectors
      • Creating a Data Connector
      • Data Connector List
        • Edit Data Connectors
        • Create Option
        • Reconnecting to a Data Connector
        • Sharing a Data Connector
        • Delete a Data Connector
      • Supported Data Connectors
        • Database Connectors
          • MySQL
          • MSSQL
          • Elastic (Beta Release)
          • Oracle
          • ClickHouse
          • Athena
          • Arango DB
          • Hive
          • Cassandra
          • MongoDB
          • MongoDB for BI
          • PostgreSQL
          • Snowflake
        • File Data Connector
        • API Connectors
          • API Connector
          • Amazon
          • App Store
          • Bing Ads
          • Dropbox
          • FTP Server
          • Facebook
          • Facebook Ads
          • Firebase DB
          • Fitbit
          • Flipkart
          • Google AdWords
          • Google Analytics
          • Google Big Query
          • Google Forms
          • Google Sheet
          • HubSpot
          • Jira
          • Lead Squared
          • Linkedin
          • Linkedin Ads
          • MS Dynamics
          • Mailchimp
          • QuickBooks
          • SalesForce
          • ServiceNow
          • Twitter
          • Twitter Ads
          • Yelp
          • YouTube
          • ZOHO Books
        • Others
          • MS Sql Olap
          • Data Store
          • OData
          • Spark SQL
          • AWS Redshift
          • SAP HANA
    • Data Sets
      • Creating a New Data Set
        • Creating a New Data Set using RDBMS Connector
        • Creating a Data Set using Arango DB Connector
        • Creating a Data Set using an API Connector
        • Creating a New FTP Data Set
        • Creating a Data Set based on an Elastic Connector
      • Data Set List
        • View Options: Data Sets List Page
        • Data Set List: Actions
          • Editing a Data Set
          • Sharing a Data Set
          • Publishing a Data Set
          • Push to VCS
          • Pull from VCS
          • Deleting a Data Set
          • Data Preparation
          • Visualize
            • Deleting a Widget
    • Data Stores
      • Creating a New Data Store
        • Data Store using an RDBMS Connector
        • Data Store using an API Data Connector
      • Data Stores List
        • Edit a Data Store
        • Refresh Data for a Data Store
        • Store Info
        • Sharing a Data Store
        • Adding Synonyms to a Data Store
        • Refresh Synonyms
        • Push to VCS
        • Pull from VCS
        • Delete a Data Store
        • Visualize
          • Deleting a Widget
    • Data Store Meta Data
      • Creating a New Meta Data Store
      • Data Store Meta Data List
        • Editing Meta Data Store
        • Store Details
        • Adding Synonyms to Meta Data Store
        • Refresh Synonyms
        • Sharing a Metadata Store
        • Deleting Meta Data Store
    • Data Sheets
      • Creating a New Data Sheet
      • Editing a Data Sheet
      • Publishing a Data Sheet
        • Entering Data
        • Applying Filter
        • Deleting a Row
      • Removing a Data Sheet
    • Data Sandbox
      • Creating a New Data Sandbox
      • Data Sandbox List
        • Upload File Status
        • Using the Data Preparation Option
        • Deleting a Data Sandbox
        • Visualize
          • Deleting a Widget
        • Create Data Store
        • Reupload
        • Preview
        • Create Datasheet
    • Data Catalog
    • Data as API
    • Data Preparation
      • Accessing the Data Preparation Option
      • Data Preparation Workspace
        • Data Preparation Landing Page
        • Profile: Summary Pane
          • Charts
          • Suggestions
          • Info: Values/Statistics
          • Pattern
        • Transforms
          • Advanced
          • Anonymization
          • Columns
          • Conversions
          • Data Cleansing
          • Dates
          • Functions
          • Integer
          • ML
          • Numbers
          • String
        • Steps
      • Data Preparation List
        • Rename
        • Edit
        • Delete
Powered by GitBook
On this page
  1. Data Center
  2. Data Preparation
  3. Data Preparation Workspace
  4. Transforms

Conversions

PreviousColumnsNextData Cleansing

Last updated 1 year ago

Convert Duration

The transform converts any duration (day, hour, minute, seconds, milliseconds) to any specified duration.

To perform the transform, select the column which has the duration to be converted and specify the duration type.

Check out the given illustration on how to apply Convert Duration.

  • Select a column from the data set with the time duration.

  • Navigate to the Transforms tab.

  • Select the Convert Duration transform from the Conversion category.

  • Enable the Create new column option to create a new column.

  • From: The type of source interval

  • To: The type of destination interval

  • Precision: The decimal points to be retained.

  • Click the Submit option.

  • The selected column values undergo a transformation to align with the chosen conversion duration. E.g., For instance, in this scenario, the selected column values undergo a conversion, transitioning from the unit of days to hours.

Convert Duration
Applying the Convert Duration transform
Column with the transformed values