Data Conversion

Contents[Hide]

The Data Conversion transform allows you to change the data type of a column.

Data Conversion transform
Data Conversion transform

1. Input

This transform requires one input transform with at least one column.

As an example, data coming from a CSV file may have been recognized as a string of text when it's known to contain dates.

Data Conversion - Input Data
Data Conversion - Input Data

Tip
If you have access, you can change the data type for a flat file by editing the data connector.

2. Configure

In the Data Conversion configuration dialog, you can choose a new data type for each column from the corresponding drop down list:

Data Conversion configuration
Data Conversion configuration

When choosing DateTime, a new Format field will appear, allowing you to enter the format to be used to correctly identify each part of the text as a part of the date and time.

DateTime format
DateTime format

For example, the format for the text 2014-01-21T20:28:21.703 would be yyyy-MM-ddTHH:mm:ss.fff. See .NET Custom Date and Time Format Strings for details.

3. Output

The figure below illustrates the output from the transform in our example.

Sample output
Sample output

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri