You are here: Processor Library > Advanced > Expression

Expression

The Expression processor allows you to write an expression which may encompass the logic of a number of other OEDQ processors and other functions, using an abbreviated expression language.

Use

Expressions are useful where the required logic of a processor can be expressed most logically and succinctly by writing an expression, rather than by configuring several processors. This is commonly the case when performing mathematical operations, for example.

Configuration

Inputs

The Expression processor may take any number of inputs, of any type, with the exception of formal Date attributes.

Options

Option

Type

Purpose

Default Value

Expression to evaluate

Expression

The required processor logic, in OEDQ's expression language. See notes below.

None

Click for detailed notes on OEDQ's expression language.

Outputs

Data attributes

Data attribute

Type

Purpose

Value

ExpressionResult

Added

Stores the result of the expression

An attribute with the result of the expression. The attribute type depends on the expression. See notes above.

Flags

None

Execution

Execution Mode

Supported

Batch

Yes

Real-time Monitoring

Yes

Real-time Response

Yes

Results Browsing

The Expression processor presents no summary statistics on its processing.

In the Data view, each input attribute is shown with the ExpressionResult attribute to the right.

Output Filters

None

Example

In this example, the Expression processor is used to divide one numeric attribute value by another.

The following two attributes are input, and the output attribute (ExpressionResult) renamed to DerivedLTV1:

The following expression is used:

Results:

 

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