You are here: Processor Library > Maths > Subtract

Subtract

The Subtract processor subtracts one numeric value from another. Both numeric values are input from attributes.

Use

Use Subtract to subtract one numeric value from another.

Configuration

Inputs

One numeric attribute to subtract from, and one numeric attribute to subtract.

Options

None

Outputs

Data attributes

Data attribute

Type

Purpose

Value

SubtractedValue

Added value

A new Number attribute with the result of the subtraction

The numeric result of the subtraction operation.

Note: If you attempt to subtract from a Null value, this is treated as different from subtracting from 0 - the result in this case will always be Null. If you wish to treat Null values as 0, you should use a Replace processor to replace Null values with 0.

Flags

None

Execution

Execution Mode

Supported

Batch

Yes

Real time Monitoring

Yes

Real time Response

Yes

Results Browsing

The Subtract processor presents no summary statistics on its processing.

In the Data view, the input attributes are shown with the new SubtractedValue to the right.

Output Filters

None

Example

In this example, a Discount attribute is subtracted from a Retail Price attribute to give the final order total.  The new attribute is named SubtractedValue by default, but in this example has been renamed to 'Order Total'.

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