Converting Text Columns to Date or Time Columns
You can convert any text column to a date, time, or timestamp column.
For example, you can convert an attribute text column to a true date column.
- On the Home page, open a dataset or workbook.
- Select the dataset, click the Actions Menu
, and then select Open. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
- Select the workbook that contains the dataset, click the Actions Menu
, select Open, then click Data. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
Note:CIC Analytics displays a Data Diagram for single-table datasets or a Join Diagram for multi-table datasets.
- Select the dataset, click the Actions Menu
- Hover over the column that you want to convert.
- Click Options and select one of the conversion options, for example, Convert to Number, or Convert to Date.
CIC Analytics adds a step to the Preparation Script panel.
- To save your data preparation changes and apply them to your data, click Save Dataset.
If you're working with a single table dataset or a file-based dataset, click Apply Script.
The changes you make apply to all workbooks using that data source.
Related Topics
Preparing your Data Set for Analysis
About Data Enrichment and Transformation in CIC Analytics
Enriching and Transforming Your Data
Accepting Enrichment Recommendations
Transforming Data Using Column Menu Options
Transforming Data Using Replace
Adjusting the Display Format of a Date or Number Column
Creating a Bin Column When You Prepare Data
Configuring Column Properties in a Dataset
Restoring a Hidden or Deleted Column
Editing the Data Preparation Script
Creating Calculated Data Elements in a Workbook
Last Published Friday, December 8, 2023