Field Type Converter

Data Collector

The Field Type Converter processor converts the data types of fields to compatible data types. You might use the processor to convert the data types of fields before performing calculations. You can also use the processor to change the scale of decimal data.

You configure the processor to use one of the following methods to convert data types:

By Field Name

Convert the data type of a field with the specified name. For example, you can convert a field named dropoff_datetime with the String data type to the Date data type.

You can specify individual field names or use field path expressions to specify sets of fields to convert.

By Data Type

Convert the data type of all fields with the specified type. For example, you can convert all fields with the Decimal data type to the String data type.

You can convert data types by field name or by data type. You cannot use both methods in the same stage.

Configure the conversion for an appropriate, compatible data type. Consider the actual data in the field as well, since even valid conversions can truncate data. For example, converting a field from Integer to Decimal is valid. Converting a field from Decimal to Integer is also valid, but the conversion can truncate any decimal values in the data.

Tip: You can use data preview to verify the data in the fields.

When you convert string data to a Date, Datetime, or Time data type or when you convert date, datetime, or time data to the String data type, you specify the date format that you want to use. You can use any valid format.