|
7.2.13Transforming Data in a Dataset
You can change the data type and format of data within a particular column.
Note:
The options available to transform data depend on the data type of the selected column.
About this task
Use this task to transform data in a column.
Procedure
1.Open the dataset for which you want to transform data.
2.Right-click in the column that you want to transform data.
The system displays the context menu.
(4).png)
Transform data—the context menu
3.Click Transform from the menu.
The system displays the options available to transform data based on the data type of the selected column.
(4).png)
transform data—options available for the transform menu
4.Click any of the options in the following table to apply that operation:
|
Data Type
|
Option
|
Description
|
|
String
|
Uppercase
|
Use this option to convert the characters in lowercase to uppercase in the selected column.
|
|
Lowercase
|
Use this option to convert the characters in uppercase to lowercase in the selected column.
|
|
Capitalize
|
Use this option to capitalize the data of the selected column.
|
|
Data Type
|
Use this option to change the data type of the data within the selected column.
|
|
More
|
Use this option to access the advanced options. The advanced options available depend on the data type of the data within the selected column.
|
|
Numeric
|
Data Type
|
Use this option to change the data type of the data within the selected column.
|
|
More
|
Use this option to access the advanced options. The advanced options available depend on the data type of the data within the selected column.
|
|
Datetime
|
Make timepart zero
|
Use this option to convert the timepart of the datetime type of the selected column to zero.
|
|
|
First date of month
|
Use this option to convert all dates of the selected column to the first date of their respective month.
|
|
|
Last date of month
|
Use this option to convert all dates of the selected column to the last date of their respective month.
|
|
|
Data type
|
Use this option to change the data type of the data within the selected column.
|
|
|
More
|
Use this option to access the advanced options. The advanced options available depend on the data type of the data within the selected column.
|
|