Page History
Overview
Once a step has been configured in the transformation flow, data will appear in the data preview panel in the form of column fields. You can then convert the datatype data type of a field into something that suits your requirements. For example, text can be converted into numeric values, SQL date, or SQL timestamp.
This type of transformation is done directly on the data in the data preview panel. Click on the drop down icon next to a field’s datatype data type and select the target data type.
Types of Data Type Conversions
This table explains all the different types of datatype data type conversions.
Note: These are the Yellowfin View 's view level converters. Users can write their own type of converters and include them in the platform.
Data type conversion | Related type | Description |
---|---|---|
Text to Numeric | Text | To convert a text or string into numeric values. However, this will only work if the data values are numbers. |
Text to SQL Date | Text | To convert text to SQL date. |
Text to SQL Timestamp | Text | To convert text to SQL timestamp. |
Java timestamp | Numeric | To convert numeric value to a Java timestamp. |
Numeric | To divide the values with a specified denominator. |
Note: Most of these are simply selections and don't require further steps.
Anchor | ||||
---|---|---|---|---|
|
Numeric Divide
This is used to divide the data by a denominator and return the results in the same column.
- Expand the data conversion menu of a numeric field.
- Click on Numeric Divide.
- In the popup, enter a denominator value to divide the data with. And click on Submit.
- The numeric field will then display the result of this division.
Styleclass | ||
---|---|---|
| ||