Matrix lookup

This is the equivalent of an Excel pivot table, in which values are read from a row-column union index. This is also known as an x-y lookup, where x corresponds to the rows and y corresponds to the columns. Values are retrieved based on a unique combination of the two dimensions x and y then populated in the target field. You can set up input pipes that look up a range of values rather than matching values. For matrix lookups, you can set up one or two ranges for the lookup. When you use a range lookup, the field represents the lower limit of the range. For additional information, refer to Input pipe range lookups.

Once you have selected the data source and table, use the process below to complete the definition of a matrix lookup input pipe.