Data Conversion

Contents[Hide]

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

Data Conversion transform
Data Conversion transform

1. Input

The Data Conversion transform requires 1 input transform that has at least 1 column.

For example, data coming from a CSV file may be recognized as a String but it is known to be a DateTime (e.g. the ModifiedDate column).

Data Conversion - Input Data
Data Conversion - Input Data

2. Configure

In the Data Conversion configuration dialog, you must configure the following settings:

  1. Select the columns you want to be included on the output.

    Data Conversion configuration - Step 1
    Data Conversion configuration - Step 1
    When using CSV files as data source, numeric data types are auto-detected as Double. All others data types are auto-detected as String.

  2. For each selected column, use the dropdown list to select a new data type.

    Data Conversion configuration - Step 2
    Data Conversion configuration - Step 2

The format required for converting into Date/Time depends on the structure of the input string

3. Output

The figure below illustrates the output from the Data Conversion transform.

Data Conversion - Sample Output
Data Conversion - 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