|
|
Select Array Element |
The Select Array Element processor extracts a numbered element from an array into a new attribute.
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.
A single Array attribute from which to select an array element
|
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 |
|
Data attribute |
Type |
Purpose |
Value |
|
ArrayElement |
Derived |
Holds the selected array element |
The value of the selected array element |
None
|
Execution Mode |
Supported |
|
Batch |
Yes |
|
Real time Monitoring |
Yes |
|
Real time Response |
Yes |
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.
None. All records input are output.
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.