Data Type Definition

Properties that can be configured for the Data Type Definition Preparation Component.

Syntax Use this component to change the name, data type, and date format of the source column.
Defining the data type helps you to prepare data to make it suitable for further analysis.
For example:
  • If the name of the column in the data source is "des", it may not be clear during analysis. You can change the name of the column to "Designation" in the analysis, so that the end users can easily understand it.
  • If the date is stored in the mmddyy (120201, without any date separator) format, it may be considered as an integer value by the system. Using the Data Type Definition component, you can change the date format to any valid format such as mm/dd/yyyy, or dd/mm/yyyy, and so on.
To change the name, data type, and the date format of the source column, perform the following steps:
  1. Add the data type definition component into the analysis.
  2. From the component's contextual menu, choose Configure Properties.
  3. To change the column name, enter an alias name for the required source column.
  4. To change the data type of the column, select the required data type for the source column.
  5. Choose Done.