You are here: Processor Library > Transformation > Select Array Element

Select Array Element

The Select Array Element processor extracts a numbered element from an array into a new attribute.

Use

Use this process to select a single element from an array for further processing. For example, if you have split the values in an attribute using Make Array from String into an array, you may use Select Array Element to extract the elements into new attributes.

Configuration

Inputs

A single Array attribute from which to select an array element

Options

Option

Type

Purpose

Default Value

Array index

Number

Specifies the numbered element in the array that you wish to select and extract

1

Count from end?

Yes/No

Determines whether or not to count from the end of the array attribute rather than from the beginning

No

Outputs

Data attributes

Data attribute

Type

Purpose

Value

ArrayElement

Derived

Holds the selected array element

The value of the selected array element

Flags

None

Execution

Execution Mode

Supported

Batch

Yes

Real time Monitoring

Yes

Real time Response

Yes

Results Browsing

The Select Array Element transformer presents no summary statistics on its processing.

In the Data view, the input array attribute is shown with the new selected element attribute to its right.

Output Filters

None. All records input are output.

Example

In this example, Select Array Element is used to extract the first element from a NAME array into a new attribute:

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