You are here: Processor Library > Transformation > Convert Number to String

Convert Number to String

The Convert Number to String transformer takes any number of Number attributes and converts them to a String type.

Use

Use Convert Number to String where you want to treat a number as text for processing purposes, or because you are migrating data to a target system with a different data type, for example where telephone numbers are stored as text fields rather than numbers.

Configuration

Inputs

Any number of Number attributes that you wish to convert to a String type.

Options

None

Outputs

Data attributes

For each attribute input, a new attribute is created in the following format:

Data attribute

Type

Purpose

Value

[Attribute Name].NumberToString

Derived

Stores the result of the Number -> String conversion

The original attribute value, converted to a String type

Flags

None

Execution

Execution Mode

Supported

Batch

Yes

Real time Monitoring

Yes

Real time Response

Yes

Results Browsing

The Convert Number to String transformer presents no summary statistics on its processing.

In the Data view, each input attribute is shown with its new derived String type attribute to the right.

Output Filters

None

Example

In this example, Convert Number to String is used to convert AREA_CODE and TEL_NO attributes to a String format in preparation for migration to a single text-based HOME_TEL field in the target system:

Oracle ® Enterprise Data Quality Help version 9.0
Copyright © 2006,2011 Oracle and/or its affiliates. All rights reserved.