Like what you see? Have a play with our trial version.

 

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 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 data type and select the target data type.

 

 

Types of Data Type Conversions

This table explains all the different types of data type conversions. 

Note: These are Yellowfin'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 Divide

Numeric

To divide the values with a specified denominator.
Numeric to SQL DateNumericTo convert numeric data to SQL date.
Numeric to SQL TimestampNumericTo convert numeric data to SQL timestamp.
Numeric to TextNumericTo convert numeric data to text.

Note: The process involved in some of these data type conversions is fairly simple, and do not require additional steps. 

 

 

 

  • No labels