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

 

Yellowfin's Data Transformation module lets you update the data type of your data fields. This is done directly on the data fields in the data preview panel.

This guide will teach you how to change the data type of your Numeric field to Date

 

Instructions

 

  1. Ensure that the data preview panel contains a numeric field that you wish to convert to a date field.
  2. Expand the type conversion menu of this numeric field, and click on Numeric to SQL Date.



  3. A new popup will appear. You may view date format patterns and examples by clicking on the information button.



  4. Enter the exact format of the date as shown in data column to convert it. The sample data will show which values will be converted as you provide the format.



  5. Specify the exact format of the date value for this numeric field. In our example above, the format that we provide is yyyyMMddHHmmSS. Only the format of the values matching this field will be converted. If we change the format to include, say, ‘/’ or ‘-’ characters, then the values will not be converted.



  6. Once ready, click Save to apply this conversion. You will be able to view the change in the data preview panel.



 

 

  • No labels