1.3.11.53 Find Matched Array Elements

The Find Matched Array Elements processor finds the common values within two or more arrays. The result contains only unique values, and values appear in the order they are present in the first array. If there are duplicate elements in all the input arrays, they will be present in the output array.

The following table describes the configuration options:

Configuration	Description
Inputs	Selected Attributes: Arrays to find values in common. Ordering of values depends on ordering in first selected array.
Options	Whether to ignore case. Default option is Yes.
Outputs	Resulting array after concatenating inputs. CommonElements: Common elements of the input attributes. HasCommonElements: Flag indicating whether any common elements were available (Y/N).

Output Filters

Filter	HasCommonElements
Has common elements	Yes
Unmatched elements	No

Example

Two inputs.

Selected Attribute A	Selected Attribute B	Matched Elements	HasCommonElements	Output Filter
(A)(B)(C)	(B)	(B)	Y	Matched
(A)	(B)	()	N	Unmatched
(A)(B)(C)	()	()	N	Unmatched
()	()	()	N	Unmatched
(<Blank>)	(<Blank>)	(<Blank>)	Y	Matched
(<Null>)	(<Null>)	(<Null>)	Y	Matched
(<Blank>)	(<Null>)	()	N	Unmatched
()	<Null>	()	N	Unmatched
<Null>	()	()	N	Unmatched
<Null>	<Null>	()	N	Unmatched

Note:

Comparing empty and null arrays are considered equivalent, as they result in an empty array and have Unmatched values.

Three inputs.

Selected Attribute A	Selected Attribute B	Selected Attribute C	Matched Elements	HasCommonElements	Output Filter
(A)(B)(C)	(B)	()	()	N	Unmatched
(A)	(B)	(A)(B)	()	N	Unmatched
(A)(B)(C)	(B)	(A)(B)	(B)	Y	Matched
(A)(B)(C)(D)	(D)(B)(E)	(D)(A)(F)(B)	(B)(D)	Y	Matched
(A)(B)(C)	(B)	<Null>	()	N	Unmatched

Note:

Common values are based on union of all inputs, not any pair of inputs