How To Use the Array Collector and Combine Arrays

There are many ways to extract array elements and normalize them for reporting. See here for a guide on how to extract array elements and here for a guide on how to manipulate the arrays in advanced ways, including filtering and sorting on the elements within. This article provides instructions for how you many combine arrays of varying lengths.

You may use the "Collector" function in the rule configurations screen to collect elements of an array together. The options you may choose are:

• Collect all values, which combines and concatenates the arrays into a larger array
• Collect if matched, which only takes the values that match within the different arrays
• Collect unique values, which only takes one of every distinct array element and avoids double-counting the same array values

 

Below is an example of a rule that extracts all unique local counterparty locations from stored Entity reference data tables of both the contraparty and the counterparty. It: