Overview
This panel provides a preview into the data that is being extracted and transformed, allowing users to see the exact impact being made on the data in real time. Changes can also be made directly to data transformation rules through this panel, such as column renaming, data type conversions, or transforming the values in a field. Note: This panel has a maximum limit of 200 values. Although that’s all the user would be able to see here, transformation would be done on all the values exisiting in the configured data source, when performing a full transformation.
Data Preview Panel Actions
You can directly perform these actions on the data through this panel:
Renaming a Field
- Click on the name of a field in the data preview panel to make it editable.
- Enter in the new name.
- Simply click anywhere else to save these changes.
Datatype Conversion
You can convert the datatype of a field into something that suits your requirements. For example, text can be converted into numeric values, SQL date, or SQL timestamp.
Click on the drop down icon next to a field’s data type and select the target data type.
This table explains all the different types of datatype conversions:
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. |
Field Transformations
You can directly transform data fields through this panel. These types of transformations depend on the datatype of the field. Click on the menu icon next to field’s name to see the types of transformations you could perform on it.
Click here to see how to perform these field transformations.